Date difference include last date

[Anonymous]

Hi,

How do I include last or start date while calculating the date difference.

I get 30 days using CheckOut-CheckIN formula. However, I want to include the start or end date so that I can get 31 NumberOfDays.

CheckIN	CheckOut	NumberOfDays
10/31/2016	11/30/2016	30

What will be the right formula to do it? Should I just do (CheckOut-CheckIN)+1 ?? Little confused here.

Thanks.

[swuehl · Accepted solution]

Just like that

(CheckOut-CheckIN)+1

[trdandamudi]

Your formula is correct and also you can use as below:

=Interval(End_Date - Start_Date,'d')+1