Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'd just like a simple formula to return the date for the current Monday, Wednesday and Friday based on the current date.

So, I would like to see it like:

  • Cell A1 I'd like (Today is Monday January 9 2012)
  • Cell B1 I'd like (Wednesday January 11 2012)
  • Cell C1 I'd like (Friday January 13 2012).
share|improve this question
    
Do you mean the Monday, Wednesday and Friday of the current week? – Paul Jan 10 '12 at 5:09
up vote 4 down vote accepted

The following will display the dates for Monday, Wednesday and Friday of the current week:

=NOW() - WEEKDAY(NOW(),3)
=NOW() - WEEKDAY(NOW(),3)+2
=NOW() - WEEKDAY(NOW(),3)+4

Basically this is taking the time now, and subtracting the current weekday (which gives you Monday), then adds 2 days or 4 days to get Wednesday and Friday.

share|improve this answer

Sunday of this current week:

=1-WEEKDAY(TODAY())+TODAY() 

Monday of this current week:

=2-WEEKDAY(TODAY())+TODAY() 

Tuesday of this current week:

=3-WEEKDAY(TODAY())+TODAY() 

Wednesday of this current week:

=4-WEEKDAY(TODAY())+TODAY() 

Thursday of this current week:

=5-WEEKDAY(TODAY())+TODAY() 

Friday of this current week:

=6-WEEKDAY(TODAY())+TODAY() 

Saturday of this current week:

=7-WEEKDAY(TODAY())+TODAY() 

SUNDAY of following week, when Monday & not Sunday is used as day #1 of week:

=8-WEEKDAY(TODAY())+TODAY()

Also, if you change the format of the cell to a custom format and choose DDD it will display Fri or Mon and if you use DDDD it will display Friday or Monday, etc.

share|improve this answer
    
When using the weekday function with a Return_Type here are the options: no ,Return_type = = 1 (Sunday) through 7 (Saturday) 1 = 1 (Sunday) through 7 (Saturday) 2 = 1 (Monday) through 7 (Sunday) 3 = 0 (Monday) through 6 (Sunday) – opsin Jan 10 '12 at 5:47

If you want it to say today is something or another:

=CONCATENATE("Today is ",TEXT(6-WEEKDAY(TODAY())+TODAY(),"DDDD"),".")

This would return: Today is Friday.

And this:

=CONCATENATE("Today is ",TEXT(6-WEEKDAY(TODAY())+TODAY(),"DDDD MMM DD"),".")

Would return: Today is Friday Jan 13.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .