Date Functions

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
 
C

Chip Pearson

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
 
A

Andy B

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")
 
Top