| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkdays & future months
"denise" wrote in message ... This looks like a great discussion group and I'm hoping someone out there will be able to help me. I'm setting up a spreadsheet for 2006 with Jan, Feb, Mar, etc out to YTD column headers and productivity items down the rows. I will be tracking each item for actual quantity and percent of monthly objective achieved. I have a holiday table set up on a separate sheet for productive days and have used the following to get the productive days for each month (using June as an example): =IF('sheet1'!$i$2="Jun",NETWORKDAYS(g28,$c$2,holid ays),NETWORKDAYS(g28,g29,holidays)) If report month is June, then show June networdays to report data date, otherwise show June total month networkdays Whe sheet1 i2 = Report Month (in this case June) g28 = June start day (06/01/06) c2 = report data date (06/16/06 as an example) g29 = June end day (06/30/06) This works fine for June and all previous months but I need to show future months as blank to prevent summing to YTD to prevent distorting averages. I know I can nest up to 7 IF statements but I haven't been able to get this working. Any suggestions are much appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Hybrid Mode
