Day of the week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

format as dddd

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



"Negin" escreveu:
 
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

Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???
 
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

Hi

Format>Cells>Number>Custom>dddd dd mmm yyyy
Choose whatever format you prefer.
 
Back
Top