Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.