Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need help on an Excel formula that will compute the SLA between 2 dates. NETWORKDAYS() doesn't include weekends and I need something that will include Saturday and Sunday.

share|improve this question
1  
Pardon my ignorance, but what is SLA (I searched, but it was ambiguous)? – jonsca Aug 15 '11 at 12:50
    
@slhck Yeah, that was my likeliest candidate, but I'm trying to figure out if all the OP needs is just the number of days between two dates... – jonsca Aug 15 '11 at 12:56
    
@slhck Thanks for bringing that one to my attention, though. – jonsca Aug 15 '11 at 13:03
3  
Possibly Service Level Agreement e.g. in business scenarios there is often an SLA that correspondence will be replied to within a certain number of days – Kris C Aug 15 '11 at 13:08

If you're just looking for the number of days between two dates, just subtract them:

      A         B      C
1  11/4/10   =NOW()  =b1-a1

If there's a time involved (like when calling =NOW()) you will end up with a fractional component, but just round as required by your industry's rules.

share|improve this answer
    
Hi! Thanks for this but I used the DATEDIF() since I also need to calculate the time and not just the number of days. – user82087 Aug 17 '11 at 7:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .