VBA Date Formula

[Octofez2]

Hello All,

First, thanks for checking this out! I have a basic formula used to get Saturday as a week ending date to use as a string for creating folders. When the code is used on a Saturday it does not detect the following Saturday. I would like to know if it's possible to tweak the below formula or something new, so if I run the code on a Saturday the code will utilize next Saturday's date?

        Dim dt As String
       
        dt = Format((Now() - Weekday(Now()) + 7), "mm-dd-yy")

 

[NARAYANK991]

Hi ,

Try this :

dt = Format(Now() - Weekday(Now(),vbSaturday) + 8, "mm-dd-yy")

Narayan

 

[Octofez2]

That did it. Thank you Narayan! Now I know how to utilize that extra parentheses.