workdays

Jagwarman
Jagwarman used Ask the Experts™
on
Could an expert provide me with the formula for the following.

In cell AF1 is the current days date.
In cell AA2 in the date of the item
I need to put in AB2 the Days aged between AF1 and AA2 minus the weekend.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi,

In AB2, enter the formula =NETWORKDAYS(AA2,AF1) to get the number of working days (ignoring any holidays that may be in there.)  There is an optional parameter for holidays which you can get more details at http://office.microsoft.com/en-us/excel-help/networkdays-HP005209190.aspx

Hope this helps!

WebDevEM

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial