Last Saturday from Today with changing date


I get a report weekly from a subcontractor that is a list of all hours worked for the week. This report can come any day of the week but always corresponds to the previous Saturday.

I want to be able to have a date column generator with last saturday’s date regardless of the day of the week it comes in. IE if the report comes in 5/20/20 then the column will read 5/16/20 for every row


If MyDate is the date the report comes in, you can get Saturday of that week with the following:
MyDate.AddDays(6 - CInt(DayOfWeek(MyDate.Year, MyDate.Day))).

1 Like

as an variation give a try on
YourDateTimeVar.AddDays(6 -YourDateTimeVar.DayOfWeek - 7)

Find starter Help here:
GetLastSaturday.xaml (6.2 KB)

1 Like