Excel Formula for First Day of Current Week (Sunday or Monday)

Excel Formula for First Day of Current Week (Sunday or Monday)

If you’d like to return Sunday’s Date of this week,
=TODAY()-WEEKDAY(TODAY())+1

If you’d like to return Monday’s Date of this week,
=TODAY()-WEEKDAY(TODAY())+2