Get next Saturday date

Try:

14/03/2023 18/03/2023

Formula:

Please Login or Register  to view this content.

11/03/2023 18/03/2023

Formula:

Please Login or Register  to view this content.

12/03/2023 18/03/2023 =A5+(7-WEEKDAY(A5))+(7*(7=WEEKDAY(A5)))
13/03/2023 18/03/2023 =A6+(7-WEEKDAY(A6))+(7*(7=WEEKDAY(A6)))
14/03/2023 18/03/2023 =A7+(7-WEEKDAY(A7))+(7*(7=WEEKDAY(A7)))
15/03/2023 18/03/2023 =A8+(7-WEEKDAY(A8))+(7*(7=WEEKDAY(A8)))
16/03/2023 18/03/2023 =A9+(7-WEEKDAY(A9))+(7*(7=WEEKDAY(A9)))
17/03/2023 18/03/2023 =A10+(7-WEEKDAY(A10))+(7*(7=WEEKDAY(A10)))
18/03/2023 25/03/2023 =A11+(7-WEEKDAY(A11))+(7*(7=WEEKDAY(A11)))
19/03/2023 25/03/2023 =A12+(7-WEEKDAY(A12))+(7*(7=WEEKDAY(A12)))
20/03/2023 25/03/2023 =A13+(7-WEEKDAY(A13))+(7*(7=WEEKDAY(A13)))

Ah, sorry missed that it was a Word requirement.

Maybe you can use the formula outlined as the basis for your VBA?

Long time since I recorded/created a macro in Word but, here you go ...

MS Word Macro:

Please Login or Register  to view this content.

Thanks for the rep.