DATEDIF Function 2010 Excel

Question

Hi All,

I'm creating this post after reading through a few similar, older questions that provided some good info but didn't solve my question, as I do not think they were getting the same results/issue.

Trying to find the number of days between two different dates that are in the same row but different columns in a large set of data.

AKA:

12/3/2015	3/10/2016	4/7/1900

8/5/2016	1/30/2017	6/26/1900

The first two columns are the original dates, and the third columns are what the following function gave me:

"=DATEDIF(G7,H7,"d")"

Which was what a number of similar posts showed as the best and most reliable way of finding this information. For some reason it always comes up with year 1900, and the month and day items it spits out are also off. I know that this is an old function that wasn't always supported so was looking for some clarity as to whether this is still the best way to make this calculation, and if not what an alternative method would be?

I could do it by hand but I have hundreds of rows of this and would rather not. I am getting my feet wet with Excel so any help would be greatly appreciated.

Thanks,

Austin

Answer 1

Hi,

Just format the third column as Numbers.  Furthermore, you can also, use this simple formula

=H7-G7

Hope this helps.

Answer 2

Hi Austin,

Please try Ashish's suggestion to see if this can help to solve the problem. Any updates please let us know when you have time.

Thanks,

Rena