using automatic dates in cells

  • Thread starter Thread starter shereea_1
  • Start date Start date
S

shereea_1

I have a worksheet and the headers are labeled with the days of the week (Mon
thru Fri) only. The next header row is labeled with the month/day/year. The
user set this up whereas just changing the function would change the day of
the week to match the date in the row below it. How is this done?
 
shereea_1 said:
I have a worksheet and the headers are labeled with the days of the week (Mon
thru Fri) only. The next header row is labeled with the month/day/year. The
user set this up whereas just changing the function would change the day of
the week to match the date in the row below it. How is this done?
Click to expand...

Example:

Mon Tue Wed Thu Fri Mon
Tue Wed
12/1/2009 12/2/2009 12/3/2009 12/4/2009 12/5/2009 12/8/2009 12/9/2009 12/10
 
Hi,

Say you have 12/1/2009 in a2 put this in A1

=A2

The format this as DDD with

Format|Cells - select Custom and enter DDD

Mike
 
Back
Top