How to get the dates of the current monday, wednesday and friday of the current week in excel?

Solution 1:

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.

Solution 2:

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.