View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Homer Homer is offline
external usenet poster
 
Posts: 9
Default Date Calculation Problem


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!