Day Of Week Formula

Thread view:

Thread rating:

carl - 23 May 2006 15:47 GMT

If I have a date like 1/22/2005, is there a formula that can tell me what day
of the week that date is ?

Toppers - 23 May 2006 15:56 GMT

Look at WEEKDAY function.

> If I have a date like 1/22/2005, is there a formula that can tell me what day
> of the week that date is ?

Toppers - 23 May 2006 15:58 GMT

A1 contains your date ......

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

> Look at WEEKDAY function.
>
> > If I have a date like 1/22/2005, is there a formula that can tell me what day
> > of the week that date is ?

David Biddulph - 23 May 2006 16:14 GMT

> If I have a date like 1/22/2005, is there a formula that can tell me what
> day
> of the week that date is ?

=TEXT(A1,"dddd")
or use the WEEKDAY() function to return a serial number for the day in the
week

Signature

David Biddulph

Pete_UK - 23 May 2006 16:19 GMT

You could just format the cell using a custom format of dddd,
m/dd/yyyy.

Hope this helps.

Pete