calculating the number of days between two dates

[rob737]

Hope all is well.

I would like some help calculating the number of days between two dates. A section from my report looks like this:

Created Closed
08/04/2016 09:16:32 06/05/2016 09:00:10
08/04/2016 08:36:42 08/05/2016 11:00:11
08/04/2016 09:14:09 08/05/2016 10:00:08
07/04/2016 12:00:29 08/05/2016 11:00:00
08/04/2016 08:05:33 08/05/2016 10:00:14
08/04/2016 11:34:00 09/05/2016 10:00:05
08/04/2016 13:24:08 08/05/2016 14:00:08
08/04/2016 10:55:58 08/05/2016 16:00:13
08/04/2016 08:26:07 16/04/2016 17:00:01
07/04/2016 11:09:02 24/04/2016 10:00:08
08/04/2016 09:15:19 08/05/2016 10:00:09
07/04/2016 11:06:03 24/04/2016 10:00:09

The created dates are in column J and the closed dates are in K. I would like to put the result into L.

The actual time is not relevant, however I don’t care if it needs to be stripped out to deliver the solution.

As always any help is much appreciated.

Many thanks
Regards
Rob

 

[MarcelBeug]

If the dates are in date/time format: =INT(K2)-INT(J2) and copy down.

 

[tygrrboi]

=DateDif(Startingdate, Endingdate, "d") d for days, m for months etc...

If you're getting a bunch of #NUM! and #VALUE! errors its because excel is probably considering those dates to be in mm/dd/yyyy format. So it will give you a NUM error if the end date is before the beginning date, and a VALUE error for the ones where you are asking for the 16th and 24th month of the year.

 

[bill351]

May sound too simple but enter in L =K2-J2 and copy down.

 

[MARK858]

May sound too simple but enter in L =K2-J2 and copy down.

It is if you are only concerned with the days as per

The actual time is not relevant

Compare the 2 results below

Excel Workbook
	J	K	L
1	08/04/2016 23:16	06/05/2016 09:00	28
2	08/04/2016 23:16	06/05/2016 09:00	27
Sheet1