Date Math Excluding Weekends

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is there a way to perform date math to exclude weekends
(and Holidays if possible) from a simple date formula
like:

=Today()-A1
where cell A1 contains the date 1/30/2004
and currently produces the value 6.

I'd like it to exclude weekends from the date math and
just consider "business" days, to produce a result of 4.

Thanks for any help!
 
=NETWORKDAYS(A1,TODAY())-1

It is part of the ATP add-in

look in help, you can also put in public holidays

Also note that it returns 5 and not 4, today's day is also included
thus the -1 at the end
 
Use the NETWORKDAYS function. See the Help menu for
guidance.

HTH
Jason
Atlanta, GA
 
Thanks, worked perfectly!!
-----Original Message-----
=NETWORKDAYS(A1,TODAY())-1

It is part of the ATP add-in

look in help, you can also put in public holidays

Also note that it returns 5 and not 4, today's day is also included
thus the -1 at the end

--

Regards,

Peo Sjoblom




.
Click to expand...
 
Back
Top