Find days between days, but including the starting date.

We travel at work, and crossing midnight counts as an additional day.

We are not basing this on 24:00 hrs passing.

I've tried datedif, days360, etc.

I need to simple count--including the calendar day I started--how many "calendar" days I've touched.


Now, to make it more annoying, the cells are formatted to show the clock times as well, BUT that's for something else.

So, here's the example:

4/1/15 18:00 to 4/2/15 00:30. It's 6 1/2 hours, but for my purposes it counts as two calendar days.

Can someone give me a hand?

Thanks as always.


J

How about something like:

=DAY(B1)-DAY(A1)+1

With first date and time in A1 and second in B1...

HTH

Originally Posted by GaryBarlow

=DAY(B1)-DAY(A1)+1

That could be problematic if the dates span seperate months.

Try
=INT(B1)-INT(A1)+1

Originally Posted by Jonmo1

That could be problematic if the dates span seperate months.

Try
=INT(B1)-INT(A1)+1

This seems to be working fine. Thanks to everyone for helping out.