Formula Assistance

**Dawn V** · 04-10-2008, 11:32 AM

Hello!

I'm not sure how to fix this one. I need to put my formula to calculate working days opposed to calendar days.

The formula that I'm using now is:

=IF(OR(U8=0,U8=""),"",IF(U8="N/A","N/A",IF(OR(U8="Same Day",U8<=7),"Compliant","Non Compliant")))

How could I change this to add working days?

**oldchippy** · 04-10-2008, 11:46 AM

Hi,

If you want working Monday-Friday, use NETWORKDAYS

http://support.microsoft.com/kb/259200

**Dawn V** · 04-10-2008, 12:02 PM

Thank you Chippy! I'm still not sure how I would use this for my calculation. I tried to type:

=NETWORKDAYS IF(OR(U9=0,U9=""),"",IF(U9="N/A","N/A",IF(OR(U9="Same Day",U9<=7),"Compliant","Non Compliant")))

& =NETWORKDAYS IF(T9="","",IF(T9="Not Completed",T9,IF(T9="n/a",T9,IF(T9-S9=0,"Same Day",T9-S9))))

I tried to evaluate the formula but, I'm just not understanding how to correct this.

**oldchippy** · 04-10-2008, 12:06 PM

Hi,

Does this work for you?

=IF(K3="","",IF(K3="Not Completed",K3,IF(K3="n/a",K3,IF(K3-J3=0,"Same Day",NETWORKDAYS(J3,K3)))))

**Dawn V** · 04-10-2008, 12:18 PM

OldChippy,

Thank you so much. I'm still learning... This site is teaching me soooo much! I wouldn't have thought to put the Networkdays at the end of the formula.

Hugs to you for your help!

~Dawn