Day of Week

[wfgfreedom]

Is there a way to identify the day of the week from a cell with the
date.

Eg. Jan 20, 2008 in cell A1 with a formula in cell A2 that displays
Sunday.

Regards,
Frank

 

[Rick Rothstein \(MVP - VB\)]

Two ways...

1) Put = A1 in A2 and use dddd as the custom format

2) Put =TEXT(A1, "dddd") in A2

The first one still has the date actual date in it, just formatted to look
like the day name (notice the word Sunday is on the right side of the cell
just like a number would be). The second one is text only.

Rick

 

[wfgfreedom]

Two ways...

1) Put = A1 in A2 and use dddd as the custom format

2) Put =TEXT(A1, "dddd") in A2

The first one still has the date actual date in it, just formatted to look
like the day name (notice the word Sunday is on the right side of the cell
just like a number would be). The second one is text only.

Rick








- Show quoted text -

Thanks for your help.

Frank