The WEEKDAY formula should be what you're looking for.

"Ken" wrote:

Excel2003

Cell A2 contains a Date ... 01/01/08

Range G4:AK4 ... contains formula which calculates Days of the month 1-31
(G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") ... etc)

Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc

Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ...
based on day of week found in Range G4:AK4.

Can I do this with "format" ... or ... do I need formula? ... Either way ...
How?

Thanks ... Kha