Re: Calculate the next date of s specific weekday
For these formulas I avoid MOD because the results are dependant on the date system (if you change to 1904 date system the formula gives a different result). The following don't depend on date system.....
For the first try
and for the second
for the latter I assume that if A1 is any date from 17th Oct to 23rd Oct 2010 then you want the result to be 27th Oct 2010