Adding seven days to a specific date, but it must always be the following Monday

[wolfgrrl]

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!

[p45cal]

Worksheet formula:
=A1+7-WEEKDAY(A1,3)
A1 contains the date from which you want the following monday. If A1 is a monday, you'll get the following monday.
In the formula, both instances of A1 could be replaced with TODAY()

[Paul_Hossler]

Try


=IF(WEEKDAY(A1)=2,A1+7,A1+9-WEEKDAY(A1))

29643

[wolfgrrl]

Thank you! This helped me get it sorted!