Day of Week
 

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

Day of Week
 

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


wrote in message
...
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

Day of Week
 

On Jan 20, 6:56*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
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

wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks for your help.

Frank