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

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.

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.