Weekending Formulas

[Huddle]

I need help in making these read correctly regardless of the day of the week. The weekending day will be Saturday.

The first formula should show the Saturday of the current week i.e. Date() is 7/6 weekending date would be 7/7.

="WEEKLY REPORT FOR WEEKENDING " & Date()-Weekday(Date())

The second formula should show the Saturday for the next week i.e. Date() is 7/6 weekending date would be 7/14.

="Prospective Inspections to be Completed by Week Ending " & Date()-Weekday(Date())+7




I think the formulas the way I have them Date() would have to be Sunday.

[JoeM]

To return Saturday date for Current Week:

="WEEKLY REPORT FOR WEEKENDING " & Date() + 7 - Weekday(Date())

For next week:

="Prospective Inspections to be Completed by Week Ending " & Date() + 14 - Weekday(Date())

[Huddle]

Works great. Thanks