# Get next Saturday date

1. ## Get next Saturday date

Hello

How can I get next Saturday date within VBA?  Register To Reply

2. ## Re: 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)))  Register To Reply

3. ## Re: Get next Saturday date

Ah, sorry missed that it was a Word requirement.

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

4. ## Re: Get next Saturday date

Thanks for your help, Yes its for Word app  Register To Reply

5. ## Re: Get next Saturday date

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.``  Register To Reply

6. ## Re: Get next Saturday date

Thanks for the rep.   Register To Reply