Calculate the first Saturday for a specific number of weeks after

[mklindquist0815]

Is it possible to calculate the first Saturday after a certain date for a specific number of weeks in Excel? Also if the certain date is a saturday already just use that date?

A class starts on a specific date and we want to find the saturday of the # of weeks in for another calculation we are using this date for.

So let's say a class starts on 5/2/2015 and we want to find the first saturday of that week (week 1) - of course this same date is saturday so the first saturday would be 5/2/2015
the second saturday after this date would be 5/9/2015 (week 2)

Week 3 = 5/16/2015
Week 4 = 5/23/2015
Week 5 = 5/30/2015
and so on

Is this possible to calculate?

[Pete_UK]

If you want to go from one Saturday to the next, you need to add 7 onto the first date. However, if your class starts on a Friday, then the next Saturday is just one day later, if it starts on a Thursday, then the next Saturday will be 2 days later, and so on. So, if you know the day of the week that the start date occurs on (which can be obtained with the WEEKDAY function), then you can easily add the relevant number of days onto it. Assuming your start date is in A2, then you can have this formula in A3:

=A2+IF(WEEKDAY(A2,1)=7,14,7)-WEEKDAY(A2,1)

which you can then copy down as far as you need to.

Hope this helps.

Pete

[mklindquist0815]

That works somewhat but we don't want it to add 1 week to the date if the actual date is saturday for Week 1 calculations