If you need to get the alternate Friday in an every other Friday scheme, you can use this version of the formula: =CEILING(A1+8,14)-8 The formula uses this fact to figure out 2nd Saturdays, then subtracts 1 to get the Friday previous. What this means is that all second Saturday's in the future are evenly divisible by 14. In this scheme, the first Friday is day number 6, the second Friday is day number 13, and day 14 is the second Saturday. It works because how dates work in Excel's default 1900 date system, where the first day in the system is the number 1, equal to the date Sunday January 1, 1900.
This formula depends on the CELING function, which rounds numbers up to a given multiple.
