ExcelBanter - i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. (https://www.excelbanter.com/excel-worksheet-functions/12960-i-need-difference-dates-down-years-ie-11-1-02-4-16-85-a.html)

nancelsb

i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85.

I need to know how to create a formula that will determine the difference of
dates down to the exact number ie 17.6

Peo Sjoblom

To get that you need times as well as dates since dates entered as dates
will always be integers
(from midnight to midnight)

with start date time in A1 and end in B1

=INT(B1-A1)+MOD(B1-A1,1)

format as General

--

Regards,

Peo Sjoblom

"nancelsb" wrote in message
...
I need to know how to create a formula that will determine the difference
of
dates down to the exact number ie 17.6

All times are GMT +1. The time now is 07:17 AM.