Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Networkdays formula
Am trying to get the agedays based on today and 20th dec , excluding
weekends( Saturday and Sunday) , Can some help me quickly |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Networkdays formula
=NETWORKDAYS("12/20/2009",TODAY())
Note you must have the Analysis Tool Pack Add-in installed Vaya con Dios, Chuck, CABGx3 "Yog" wrote in message ... Am trying to get the agedays based on today and 20th dec , excluding weekends( Saturday and Sunday) , Can some help me quickly |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Networkdays formula
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) "clr" wrote: =NETWORKDAYS("12/20/2009",TODAY()) Note you must have the Analysis Tool Pack Add-in installed Vaya con Dios, Chuck, CABGx3 "Yog" wrote in message ... Am trying to get the agedays based on today and 20th dec , excluding weekends( Saturday and Sunday) , Can some help me quickly . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS formula | Excel Worksheet Functions | |||
NETWORKDAYS formula | Excel Worksheet Functions | |||
need help with networkdays formula | Excel Worksheet Functions | |||
Networkdays formula | Excel Worksheet Functions | |||
NETWORKDAYS FORMULA | Excel Worksheet Functions |