I don't see how 23/01/06 + 9 weeks gives 14/05/07

If you want to add the number of weeks (in B1) to a date in A1 then you can
use the formula

=A1+B1*7

"Homer" wrote:


I have several jobs each with a different start date, and frequency
period before a job becomes due again. I need to automatically calculate
whether any jobs would occur the week of any given date (always a Monday).

eg Job Start Date 23/01/06 frequency 9 weeks, If I needed to know if the job
fell
on the week commencing the 14/05/07, what formula could I use?

Thanks for any help!