Help with Formula (2000 sp3)

Topic

New Reply

All,
I have a formula where I am using the function NETWORKDAYS.
=IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)).

Where I am looking at the tab Calendar for the range of days off. This all works correctly, however in the instance where the comparison between the two dates is of the same day, I am getting a return of zero for the count of days. Is it possible to have this formula indicate that this is equal to one (1) day instead of zero?

Thanks,
Brad

Reply | Quote

Replies

How about:
=IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)=0,1,NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)))

or perhaps:
=IF(NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207)<0,"",1+NETWORKDAYS(G2,X2,Calendar!$E$1:$E$207))

If you want to shift all by 1 day.

Steve

Reply | Quote

Steve,

Works Great!

Thanks,
Brad

Reply | Quote