Business Day Counter

[VadersKid]

Hello. I know about the Workday Function but I am having trouble coming up with a code for the # of Business Days since a specifice date of event. Could/does excel auto know what "Business Days" are or do I need to set those parameters ahead of time? My Business Days are M-F. Also, if anyone could give me a formula that work with what I need, it would be greatly appreciated.

Basically, I just need to know the Business Days that have elapsed from the Date of Event (Column H) and Today then put the formula into Column J.

Thanks for the help

 

[Fluff]

How about

=NETWORKDAYS(H2,TODAY())

 

[VadersKid]

How about

=NETWORKDAYS(H2,TODAY())

Perfect! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.