Day of the week

K

Khalil Handal

Hi,
A1 has a date value in cell D2 I want to obtain the day (i.e. is it Monday
or Tuesday....).
Is this possible??
 
P

Pete_UK

In D2 put the formula:

=A1

and apply a custom format to the cell - set to dddd for the full day,
or ddd for an abbreviated day.

Hope this helps.

Pete
 
Top