Day of the week
 

Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

Day of the week
 

Hi,

format as dddd

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Negin" escreveu:

Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

Day of the week
 

Assuming your date is in cell A1, try =TEXT(A1,"dddd")

HTH Rob


"Negin" <Negin @discussions.microsoft.com wrote in message
...
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

Day of the week
 

If you want a formula, would you like to try the following.

For today's date:

=TEXT(WEEKDAY(TODAY()),"dddd")

For any date that you key into A2 (e.g. 10/1/2006):

=TEXT(WEEKDAY(A2),"dddd")

You can key the formula into B2 to have "10/1/2006" and "Sunday" side by side.

See Excel Help for more details on WEEKDAY( ).

Hope this helps.

Epinn

"Negin" <Negin @discussions.microsoft.com wrote in message ...
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

Day of the week
 

Hi

FormatCellsNumberCustomdddd dd mmm yyyy
Choose whatever format you prefer.

--
Regards

Roger Govier


"Negin" <Negin @discussions.microsoft.com wrote in message
...
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???

Day of the week
 

Yes, Roger, I would do the same too. I have been thinking why a formula is needed and the only situation I can think of is that this is within another formula. Any comments?

Hope you are enjoying your weekend.

Epinn

"Roger Govier" wrote in message ...
Hi

FormatCellsNumberCustomdddd dd mmm yyyy
Choose whatever format you prefer.

--
Regards

Roger Govier


"Negin" <Negin @discussions.microsoft.com wrote in message
...
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???