extracting day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Ridgeway - 17 Nov 2007 12:59 GMT

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

Reply to this Message

Bob Phillips - 17 Nov 2007 13:16 GMT

=DAY(A1)

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

=TEXT(A1."dddd")

will give Sunday, Monday, etc.

Signature

HTH

Bob

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

>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

Reply to this Message

Bernard Liengme - 17 Nov 2007 15:36 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address

> =DAY(A1)
>
[quoted text clipped - 10 lines]
>>
>> Bill Ridgeway

Reply to this Message

Bill Ridgeway - 17 Nov 2007 16:48 GMT

Thanks all.

Bill Ridgeway

Reply to this Message

Max - 17 Nov 2007 13:18 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>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

Reply to this Message

Alan - 17 Nov 2007 13:19 GMT

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

>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

Reply to this Message

Rate this thread: