Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

up vote 3 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
add comment

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.