ANmar Date and Time / Standard functions / WEEKDAY October 17, 2023 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)