Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Planning reports
Hi There,
I would like to use excel to plan my engineer usage reports over a quarter. I have 172 Engineers that have to be reported on every 90 days. I used the NETWORKDAYS function to calculate this is approx 66 business days in 90 = approx 3 engineers a day Monday to Friday. The engineer numbers are in column A. I would like a function in colum B to calculate a modular expression where the start date is changed to the next day on the count every x amount of engineers (x = No of engineers / business days) The rolling formula is to exclude weekends, so day < 1 or 7 I figured something like this: If MODCount of coulmn A is more than 3 then previous date +1 Can anyone help here or has any experience of this as will help me very much. Thanks Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) | |||
macro to run series of reports to PDF | Excel Worksheet Functions | |||
help on excel reports for anaylsis and trending | Excel Worksheet Functions | |||
merging reports | Excel Discussion (Misc queries) | |||
Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) |