weekday

[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).

 

[Niek Otten]

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.

 

[Jason Morin]

A1: 8/6/03
B1: =A1

Custom format B1 as dddd.

HTH
Jason
Atlanta, GA

 

[Tom Ogilvy]

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