# of Workdays minus Holidays

[jmozulay]

When trying to find the number of workdays between two dates minus holidays, excel says to use NETWORKDAYS(start_date,end_date,holidays). I tried this and ended up getting one less day regardless if the holiday fell between the two dates. I made sure that the dates weren't formatted as text. What am I doing wrong?

Thanks!

[oldchippy]

See other question

http://www.excelforum.com/showthread.php?t=618027

[daddylonglegs]

Can you give an example?

What formula are you using, exactly. What are the start and end dates and holidays and result?

[oldchippy]

NETWORKDAYS

This function will calculate the number of working days between two dates, the calculation does not include the last day so try

=NETWORKDAYS(Start,End,Holidays)+1

[jmozulay]

Perfect thanks!

[daddylonglegs]

Perfect thanks!

?? Are you sure ??

Networkdays actually counts both the start and end dates (assuming they are not Sats, Suns or defined holidays)

so if I use this formula

=NETWORKDAYS(Start,End,Holidays)+1

where Start is today (a Thursday) and End is tomorrow (a Friday) the result will be 3

[oldchippy]

Yes you're right daddylonglegs

Please Login or Register  to view this content.

That's where I was going wrong. Its probably best to format the date cells to "ddd dd-mmm-yy" or something like that so that you can see the actual weekdays