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???
 
Hi

Format>Cells>Number>Custom>dddd dd mmm yyyy
Choose whatever format you prefer.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weekending Date w/Less Than 3 days Assoc. with Prior Month 7
Formula to tell day of week 2
how to check for days of the week 7
Testing a cell value for a specific weekday. 3
Assign each week number to corresponding month of the year 5
Day formula 4
Create Calculation to return number of weeks and days 6
Use array/braces **WITHIN** a formula? 3

Back
Top