extracting day

B

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
 
B

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)
 
A

Alan

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

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
 
Top