Get next Saturday date

1. Get next Saturday date

Hello

How can I get next Saturday date within VBA?

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)))

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?

4. Re: Get next Saturday date

Thanks for your help, Yes its for Word app
And I didn't get your second answer

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.``

6. Re: Get next Saturday date

Thanks for the rep.

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1