Formula to calculate the 1st Saturday after a specific dated

I have a date that changes every year and I need it to calculate the 1st Saturday that follows that date. However, if that date is a Saturday, it needs to be that dated.

I am trying to calculate the following:


D27 = Saturday, April 20, 2019 (This Date/Day can change every year)

=D27+8-WEEKDAY(D27+1) (This returns a value of Saturday April 27, 2019)

The return value of this formula need to return a value of Saturday April 20, 2019.


Please help.

Try this:

=D27+7-WEEKDAY(D27)

Thank you for your help. That worked.

Lonnie

You're welcome. Happy to help.

Thanks for the rep!