Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Nett Date Calculation | Excel Worksheet Functions | |||
Date Calculation | Excel Discussion (Misc queries) | |||
Date calculation | Excel Worksheet Functions |