Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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