Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Networkdays formula
0 views
Skip to first unread message
Yog
Dec 29, 2009, 2:44:01 PM12/29/09
to
Am trying to get the agedays based on today and 20th dec , excluding
weekends( Saturday and Sunday) , Can some help me quickly
weekends( Saturday and Sunday) , Can some help me quickly
clr
Dec 29, 2009, 10:54:36 PM12/29/09
to
=NETWORKDAYS("12/20/2009",TODAY())
Note you must have the Analysis Tool Pack Add-in installed
Vaya con Dios,
Chuck, CABGx3
"Yog" <Y...@discussions.microsoft.com> wrote in message
news:F4F5F9B9-9E35-45C7...@microsoft.com...
Sean Timmons
Dec 31, 2009, 4:45:01 PM12/31/09
to
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:
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:
> .
>
0 new messages