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)
Excel f(x)s = Excel Functions
Copyright © 2024 Excel Functions