HRspec2021
New Member
- Joined
- Jun 21, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
How do I find a formula that will output a certain date based on the date of the cell next to it? I want a formula that will give me a date that is either Monday of the same week of the date in the next cell, or Monday of the next week, depending on the day of the week which the date falls. For example, L7 is 7/20/21. I want a formula in M7 to put out 7/19/21 because 7/20/21 falls on a Tuesday. Also, L8 is 7/22/21. Because our cutoff is Wednesday (anything after Wednesday goes to the next week), I want M8 to put out 7/26/21. I hope this makes sense.