Dates

[Pete Mckenney]

I use a timesheet that requires the date to be entered in
two different cells and in different formats. How can I
enter it in cell N11 and have it also enter in cell N35
without having to type it twice???
N11 will be : Monday,June 2,2004
N35 would be June 2,2004
Pete

 

[JulieD]

Hi Pete

put
=N11
in cell N35, right mouse click on N35 choose format cells / under the Number
tab, go down to Custom, on the right hand side type
mmmm d,yyyy
and click ok

for N11, right mouse click on it, choose format cell / under number go to
Custom & type
dddd,mmmm d,yyyy

click ok

now you can enter the date in either dd/mm/yy or dd-mm-yy format into n11
and it will display in both cells correctly.

Cheers
JulieD