Datedif short one day

[stevembe]

This might be something obvious but it is confusing me. For the dates 19 Sep 16 to 30 Oct 16 the following formula calculates 41 days. However, manually counting this adds up to 42 days. 19 to 30 Sep is 12 days plus October 30 days = 42 days. Can anybody advise what I am missing?

=DATEDIF(C14,D14,"D")

Thanks in advance.

 

[Jonmo1]

It's not inclusive of both Start and End Dates.

Try just adding 1 to the result +1

 

[stevembe]

It's not inclusive of both Start and End Dates.

Try just adding 1 to the result +1

Thanks for you reply Jonmo, I see the error and your suggestion works. Much appreciated.

 

[Jonmo1]

You're welcome.

 

[Bardohh44]

This is a very old question, but I have the same exact problem. I need the total number of days for my calculation. I'm not formally trained on excel. Can I do the +1 in the same cell? Right now I am using two cells/columns,one for datedif and one to add +1. What would the combined formula look like?

 

[MARK858]

You just add one to the formula, using the formula in post 1....

=DATEDIF(C14,D14,"D") + 1

 

[Bardohh44]

Thank you! Can't believe it was that simple. Thought I was going to have to use sum as well.

 

[MARK858]

You're welcome