Hello.
I have a start date (12/31/21) from which I am adding/subtracting to determine what that date should be. For example, my formula is =WORKDAY($B$1+35,1) or =WORKDAY($B$1-120,1)
What I would really want is the start of the week (Monday). I can't quite nail the formula to add/subtract days to get a Monday start date. Also, if the addition of the number of days brings me to a Wednesday (as an example), I'd want it to be the Monday before versus the Monday following.
Thanks in advance!
I have a start date (12/31/21) from which I am adding/subtracting to determine what that date should be. For example, my formula is =WORKDAY($B$1+35,1) or =WORKDAY($B$1-120,1)
What I would really want is the start of the week (Monday). I can't quite nail the formula to add/subtract days to get a Monday start date. Also, if the addition of the number of days brings me to a Wednesday (as an example), I'd want it to be the Monday before versus the Monday following.
Thanks in advance!