extracting day

  • Thread starter Thread starter Bill Ridgeway
  • Start date Start date
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
 
=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)
 
Custom format the cell as dddd, or if you want it to display Saturday 17
November 2007,
dddd dd mmmm yyyy
Regards,
Alan.
 
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
 
Back
Top