Excel formulas

[Guest]

I'm trying to write a formula in Excel that calculates the number of days between dates in two different cells. Not too difficult, I've got that part

=(NETWORKDAYS(B3,H3,Holidays!$A$2:$A$11)-

However, H3 is not always populated. Given this, I want the function to then look at C3 where there will be a date. I just can't figure out how to do this. Any help you could provide would be GREATLY appreciated

Thanks

 

[Peo Sjoblom]

=NETWORKDAYS(B3,IF(H3="",C3,H3),Holidays!$A$2:$A$11)-1

--

Regards,

Peo Sjoblom

I'm trying to write a formula in Excel that calculates the number of days

between dates in two different cells. Not too difficult, I've got that
part:

=(NETWORKDAYS(B3,H3,Holidays!$A$2:$A$11)-1

However, H3 is not always populated. Given this, I want the function to

then look at C3 where there will be a date. I just can't figure out how to
do this. Any help you could provide would be GREATLY appreciated.

 

[Guest]

Cool! I was sure it had to have and IF in there, I just
couldn't figure out how. Thanks!!