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.
 

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

Template for calculating different number of days between 2 dates 1
Date + X days excluding holidays 1
Diff in business days 2
Expanding Date formula 1
Calculate Number of Days Between Dates Minus Weekends 3
Calculate Transaction Time Over Days 3
Date Value Error 6
Power Pivot Variance Column 0

Top