wolfgrrl
04-15-2022, 05:57 AM
Good Morning! 🌞
I'm looking for some code that would allow a future date in a cell but it must always be the following Monday. For example, Monday is 04/18/2022, so I would need the calculated date to be 04/25/2022. I do not see a way to complete this with a formula, so I'm hoping there might be some VBA code that could.
Thank you!
I'm looking for some code that would allow a future date in a cell but it must always be the following Monday. For example, Monday is 04/18/2022, so I would need the calculated date to be 04/25/2022. I do not see a way to complete this with a formula, so I'm hoping there might be some VBA code that could.
Thank you!