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.

Who is Participating?
WebDevEMConnect With a Mentor Commented:

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

Hope this helps!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.