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

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aiswarya" wrote in message
...
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

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

"Aiswarya" wrote in message
...
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

David Biddulph;233875 Wrote:
The function you need is NETWORKDAYS. As with every other Excel
function
(except one), you'll find details in Excel help.
--
David Biddulph

"Aiswarya" wrote in message
...
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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65271