Save current file to include date of current week Saturday?

[NormChart55]

Hello - I have this code saving my file, but I need to tweak it so that the date is for the Saturday of the current week and cannot find a solution. Hopefully there is a simple one. Any thoughts?

Dim Path As String
Dim Filename As String
Dim dt As String
user = Environ("Username")
Desktop = "C:\Users\" & user & "\Desktop\"

dt = Format(CStr(Now), "yyyy_mm_dd")

    Path = "C:\Users\username\Desktop\"
    Filename = "Template"

On Error Resume Next

  ActiveWorkbook.SaveAs Filename:=Desktop & Filename & " " & dt & ".xlsm", FileFormat:=52

 

[Joe4]

Use this for your "dt" calculation:

    dt = Format(Date + 7 - Weekday(Date, vbSunday), "yyyy_mm_dd")

 

[NormChart55]

Use this for your "dt" calculation:

    dt = Format(Date + 7 - Weekday(Date, vbSunday), "yyyy_mm_dd")

thanks, this worked as intended. Very much appreciated.

 

[Joe4]

You are welcome!
Glad I was able to help.

Here is a good link on the Weekday function I used, if you are interested in seeing that: Weekday function (Visual Basic for Applications)

 

[NormChart55]

thanks, this worked as intended. Very much appreciated.

Use this for your "dt" calculation:

    dt = Format(Date + 7 - Weekday(Date, vbSunday), "yyyy_mm_dd")

Is there a way to adjust that to Monday of current week for a different file? I played around with changing the + 7 to a minus 7 and adjusted vbSunday to Tuesday, but it goes to the past weeks date. If I leave the +7 it does the Monday for the next week and not current.

 

[Joe4]

Is there a way to adjust that to Monday of current week for a different file? I played around with changing the + 7 to a minus 7 and adjusted vbSunday to Tuesday, but it goes to the past weeks date. If I leave the +7 it does the Monday for the next week and not current.

Take a look at the link I provided, where you can choose a different day for the start of the week, and play around with it.
Off the top of my head, I am not sure if you might have to use an IF to check to see if you are before/after the date already (you might need to do one calculation if it before the weekday, and another if it is after it.

 

[NormChart55]

Take a look at the link I provided, where you can choose a different day for the start of the week, and play around with it.
Off the top of my head, I am not sure if you might have to use an IF to check to see if you are before/after the date already (you might need to do one calculation if it before the weekday, and another if it is after it.

thanks again, hope you have a wonderful day

 

[Joe4]

You are welcome.

If you have any issues, show us what you tried, and a few example of different scenarios and what you want to return for each one.