Number of working days between 2 dates

M

mansfieldtw

So I've seen similar posts; however, no solutions to this problem.
Using the networkdays formula, I calculated the number of working days
between the due date and the completed date...

=NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)

where K1=Date Complete (5/1/07)
G1=Due Date (5/1/07)

I would think the result of the formula would = 0, since the due date
and date complete are the same. Instead, the result is 1. Any
suggestions how I can count the number of days in between the 2 dates
to reflect Days Early/Late? Thanks in advance for your help.

-T
 
C

CLR

A couple of thoughts............if you want your formula to result in zero
when both dates are the same, try

=NETWORKDAYS(K1,G1, 'Holiday Chart'!$A$2:$A$18)-1

or maybe just put =G1 as one of your holidays....

hth
Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
Calculate business days between 2 dates 2
Average of Days Between Customers Visits 0
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Counting average number of days between 2 dates 3
Days between two dates? 1
converting working hours to days 2
Count specific days in between dates 2

Top