extracting day

[Bill Ridgeway]

I want to extract the day (Saturday) from a date (17/11/2007) for use in a
formula to apply pay rates according to the day..

Thanks.

Bill Ridgeway

 

[Bob Phillips]

=DAY(A1)

will give the day number (1 = Sun, 2 = Mon, etc.)

=TEXT(A1."dddd")

will give Sunday, Monday, etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Max]

One way
If A1 contains a real date
In B1: =TEXT(A1,"dddd")

 

[Alan]

Custom format the cell as dddd, or if you want it to display Saturday 17
November 2007,
dddd dd mmmm yyyy
Regards,
Alan.

 

[Bernard Liengme]

Bob meant to type =WEEKDAY(A1) to get 1 = Sun, 2 = Mon, etc.
DAY() returns the calendar date; DAY(TODAY()) will return 17 today
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address

 

[Bill Ridgeway]

Thanks all.

Bill Ridgeway