Apologies

The formula in D2 should be
=IF($A2+7*$C2<$D$1,"",IF(AND($A2+7*$C2=D$1,$A2+7* $C2<=E$1),$B2,""))

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

If you wanted a grid to see when jobs were due, you could use the
following.
Assuming Date of job is in column A, Job number in Column B and
Frequency (weeks) is in column C.

In D1 enter
=INT(TODAY()/7)*7+2
This will give the Monday of the Current week
In E1 enter
=D1+7 and copy across as far as required
In D2 enter
=IF($A2+63<$D$1,"",IF(AND($A2+7*$C2=D$1,$A2+7*$C2 <=E$1),$B2,""))
and copy across for the same number of columns as you have dates
entered in row 1.
Copy this row of formulae down as far as required.

Now the Job number will show up under the appropriate column for you,
and will be constantly adjusted as each starting week number gets
adjusted through the formula in D1.


--
Regards

Roger Govier


"Homer" wrote in message
...

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!