LastSunday, LastSaturday

October 17, 2023

Get the date of the most recent SUNDAY for a specific date:
D12 is the cell containing the date

=D12 - WEEKDAY(D12) + 1

While Saturday is easier

Get the date of the most recent SATURDAY for a specific date:

=D12 - WEEKDAY(D12)

An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that