weekday

  • Thread starter Thread starter monica
  • Start date Start date
M

monica

How do you get Excell 2000 to automatically show a weekday
based on a reference from a date cell? I did it about 6 or
7 years ago with an old version by subtracting a date
number from the current date (as a numeric value).
 
If you want today (Aug 6, 2003) to be displayed as Wednesday, just
Format>Cells>Custom and use dddd as type.
If you require a number, put a WEEKDAY() function in another cell. Look in
Help for details: there are several weekday numbering systems.
 
Assume the date is in A1 and you are filling down starting in A2

=A1+CHOOSE(WEEKDAY(A1),1,1,1,1,1,3,2)

Regards,
Tom Ogilvy
 
Back
Top