How to calculate the number of days between two dates

A

Aiswarya

I am trying to calculate the difference in dates between two dates for SLA
calculation.The output ( i.e number of days) should exclude the weekends and
holidays
 
D

David Biddulph

The function you need is NETWORKDAYS. As with every other Excel function
(except one), you'll find details in Excel help.
 
P

Pecoflyer

David said:
The function you need is NETWORKDAYS. As with every other Exce
function
(except one), you'll find details in Excel help.
Click to expand...

You'll need to install teh analysis Toolpak for networkdays t
function.
Are your week ends saturday and sunday

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 

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

Creating a Search using a combo box and then creating a report. 4
Expanding Date formula 2
date calculation in pivot table to show products over agreed date? 0
Template for calculating different number of days between 2 dates 2
Power Pivot Variance Column 0
number of months and days between two dates without approximation 3
Date + X days excluding holidays 1
Diff in business days 2

Top