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.