Is there a better way of solving this?

[uwish7]

I want to have the date give a Monday date. So 8/24/18 will be 8/20/18 but if 8/13/18, a Monday date, then it should show 8/13/18. I was going to create a cell for days of the week and write an if statement. this s y formula without the cell text [TABLE="width: 107"]
<colgroup><col width="143" style="width: 107pt; mso-width-source: userset; mso-width-alt: 2490;"> <tbody>[TR]
[TD="width: 143, bgcolor: transparent"]=B5-WEEKDAY(B5-2)[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

That is a solid formula.
If it is working correctly for you, there is no reason to change it.

 

[uwish7]

I figured it out. Thanks.

 

[uwish7]

a2-Weekday(a2,3)