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

extracting day - 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)

extracting day - Max

One way
If A1 contains a real date
In B1: =TEXT(A1,"dddd")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

extracting day - Alan

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

extracting day - 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

extracting day - Bill Ridgeway

Thanks all.

Bill Ridgeway