Networkdays and Days Aged Question

[#1]

I was wondering if someone could give me some examples of formulas I can use to solve my issue:

Example

Issue:  A Work Order is created on 12/1/2014 and closed 12/12/2014.  That is technically 12 days but two of them are weekends which no work gets done.  I want to base my days aged on NetWorkdays if that is possible.

Any ideas would be welcomed.

Thanks,

David

[saurabh5 · Accepted solution]

hi David,

you can use the networkdays function it will give you 10 days,

eg:

=

NetWorkDays(date(F1),date(F2))

where f1 is created date

          f2 is closed date

regards

Saurabh