Networkdays formula

Y

Yog

Am trying to get the agedays based on today and 20th dec , excluding
weekends( Saturday and Sunday) , Can some help me quickly
 
C

clr

=NETWORKDAYS("12/20/2009",TODAY())

Note you must have the Analysis Tool Pack Add-in installed

Vaya con Dios,
Chuck, CABGx3
 
S

Sean Timmons

One other thought, assuming you do not want to include holidays (Christmas,
in this example), you will need to enter the holiday dates somewhere and
include the range in the formula like so:

=NETWORKDAYS("12/20/2009",TODAY(),A2:A10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
How can I count the number of SATURDAYS in a month? 2
Calculate days help 2
NETWORKDAYS 2
Change the weekends 1
Remote stopped working in PowerPoint Presenter View 0

Top