"denise" <denise@discussions.microsoft.com> wrote in message
news:3493FD9E-3A92-4548-9641-4B6698261015@microsoft.com...
> 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,holidays),NETWORKDAYS(g28,g29,holidays))
>
> If report month is June, then show June networdays to report data date,
> otherwise show June total month networkdays
>
> Where:
> 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!