Networkdays

[MickeyD]

I'm about to go bonkers

I'm not a SME with Excel, but get by. Building a simple gantt chart. I have the conditional formatting working but can't get the Networkdays to work.

I put in =NETWORKDAYS(C22,C23,Holidays!B5).

C22 is the start date (6/1/2015) C23 is the end date (8/1/2015), and B5 is the only holiday in there (7/3/2015) on a tab named Holidays.

But when I put that in the first cell for 6/1, it returns the date of 2/13. Don't know why. I don't see a way to attach an image - it's on my desktop and I'm pretty sure our company won't let me enter a URL for that.



Thanks,

 

[DRSteele]

Well, you're going to gasp when you know why 2/13 comes up. The number of net workdays is 44; if you format 44 as a date you get 2/13 (of 1900, by the way). Format the cell that contains the formula as a number, not as a date.

Don't fell too bad...go have a beer and a laugh.

 

[iggydarsa]

Change the format of the cell to General... then it will show 44 instead of 2/13

 

[elmer007]

2/13 is the date for the number 44. If you change the number format you'll see that it's actually 2/13/1900.

 

[MickeyD]

Okay, I get that, but what I'm trying to do is put dates in a calendar bar across the top of my gantt chart based on the start and end dates, and skipping weekends and holidays. How does that happen. And, I will have that beer tonight