Date Functions

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Is there a function to convert a date into a day of the week?

e.g. A1 = 21-Mar-2004 and is formatted as a date; in B1 I want to show that
this is a Sunday.

TIA
Craig
 
Craig,

If you want to preserve the actual date value in the cell, and
only display the day of week name, use a custom number format of
'dddd'. If you want to actually convert the date in to a day of
week name, use =TEXT(A1,"dddd")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi

You can format the cell the date is in as dddd for Sunday. Or you can
create a text cell with:
=TEXT(A1,"DDDD")
 
Back
Top