Get Day of a DATE

[a_20120]

Hello everyone,
I want to get the DAY of the DATE like (Sunday, March 04, 2007
), and I use the formula =DAY(Sunday, March 04, 2007), but unfortunately it return the Wednesday. but on some date it works correctly.
Can anyone plz tell me How it is possible to get the exact DAY of a DATE.

 

[boblarson]

=Format([YourDateFieldHere],"dddd")

 

[a_20120]

Thanks for Quick Replying,
I am using EXCEL, are u sure the Format works in EXCEL as formula?

 

[boblarson]

If you are using Excel, just set the formatting of the cell to Custom and type in dddd into the custom format.

 

[a_20120]

thnx again,
I did what u say, also I use the formula =DAY(Sunday, March 04, 2007), but it gives me the Wednesday.
The third of march is SUNDAY...
But if I use =Day(Today()), it gives me the correct day WEDNESDAY...

 

[a_20120]

for further information. I should tell u I am going to make a timesheet for the staff. actually the from 20th of the last month up 20th of the current month. and I have in list box (20/1/2007, 20/2/2007, 20/3/2007 ... 20/12/2007).
What I want when the Staff select the 20/1/2007 from the list box. just the exact day of that month appears, and then I use the incrementing of that to go to the next day and next after day...
Thanks in Advvanced

 

[boblarson]

No, you're not understanding.

You don't need a formula

Just select the cells that you want to display as the day and right-click and select FORMAT CELLS. Then, select Custom (instead of one of the Date formats). In the custom format type dddd.

Then, if you want the cell to get it's value from another cell you just set the formula of the cell to something like =A4

See attached sample.

 

[unmarkedhelicopter]

Day() works on a serial number, which gets interpreted as a date (or date and time).
So when you say you use "=Day(Sunday, March 04, 2007)" you should just get an error. I don't know how you are getting anything but an error.
If you have a serial number then the cell must be formatted as "dddd, mmm dd, yyyy" This is a very strange format anyway.
What boblarsen is saying is that you can just reference the cell e.g. =A2 then you format the destination cell as "dddd".

If you don't understand any of the above then please identify which bits you don't.

 

[a_20120]

TimeSheet

Thanks all of you,
for further information you can have a look at the attachment,

 

[shades]

So, you want the day of the week for the 20th of each month? (According to your list in column I)?

If I understand correctly, then, B17: B23 will have the days of the week, starting from whatever day of the week matches with the 20th in A17.

Guess I am missing what you want.
________
MERCEDES-BENZ M-CLASS SPECIFICATIONS

 

[a_20120]

Thnx for replying all of u,
Yeah the, B17: B23 will have the days of the week which is selected from C4.
also what I need else is F13, I need the F13 contains the next 20th month of the C13.
Thanks all...