Counting Days including Start and End Date

[mssktty]

Hello,

What function can I use to count days from a start date to an end date with the count including the start and end dates. For example, 04/01/09 - 06/30/09 is 92 days. The DATEDIF function only counts the days between or 90 days. I would like a function to return the value of 92 days.

Thanks!

Colleen

 

[jbeaucaire]

DateDif is still the function to use, since you know you want an "adjusted" answer, just adjust it.

=DATEDIF(E1,F1,"d")+2

...or even:

=F1-E1+2

 

[barry houdini]

Surely the result is 91 even counting start and end dates, April and June have 30 days each, May has 31, so it would only require +1........

 

[mssktty]

Thank you both very much!