Day of the week

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
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??
 
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
 
Back
Top