DATEDIF function is not working in Excell 2013

[SoftwareUzer]

Property Address: Days on the Market: Date listed (C5) Date Sold: (D5)
123 Excel Street #NUM 1/12/2016 4/12/2016

=Datedif(D5,TODAY(),"Y")

This formula/function works fine in Excel 2010, but its not in Excel 2013. Instead, I get #NUM in the cell.

Please help!

[Tony Valko]

Whatever is in C5 is not a true Excel date.

Format the cell as Date then re-enter the date (in that order!).

[Jonmo1]

I can only get the #NUM error if the date in D5 is greater than today's date.
Which appears to be the case in your example

Property Address: Days on the Market: Date listed (C5) Date Sold: (D5)
123 Excel Street #NUM 1/12/2016 4/12/2016

[Jonmo1]

Whatever is in C5 is not a true Excel date.

In that case, the error would be #Value!, not #Num!

[Norie]

Have you got D5 and TODAY() the right way round?

[Tony Valko]

In that case, the error would be #Value!, not #Num!

Yes, good catch.

[SoftwareUzer]

The date was already formatted correctly but still it is not executing.

=Dateif(D5,Today(),"Y")

A.K.A. =Dateif(4/12/2016,TODAY(),"Y")

has something changed in 2013?

[SoftwareUzer]

Correction =Datedif(D5,Today(),"Y")

[Tony Valko]

Did you see post #3?

Tell us what date is in D5.

[Jonmo1]

=Dateif(D5,Today(),"Y")

A.K.A. =Dateif(4/12/2016,TODAY(),"Y")

has something changed in 2013?

Nothing has changed.
Datedif(startdate,enddate,"Y")

The Start Date cannot be greater than the End Date (we can't travel backwards in time....Yet)

[SoftwareUzer]

OOOOhhh Shizzit! It worked Jonno1. =Datedif(C5,D5,"Y")

=Datedif(D5,TODAY(),"Y") works fine in Excel 2010
Anyhow, thanks

[Sam Capricci]

you know you can tweak the datedif formula for the occasions the dates are reversed. =iferror(Datedif(C5,D5,"Y"),Datedif(D5,C5,"Y")) or =IFERROR(DATEDIF(C5,TODAY(),"Y"),DATEDIF(D5,TODAY(),"Y"))

[SoftwareUzer]

That's good to know Sambo kid

[SoftwareUzer]

Where do I indicate or what button do I click for problem solved on this post?

[Manoj Mohite]

Change the date format in to DD-MMM-YYYY. 04-Nov-2018.

It will solve this problem.

=DATEDIF(X2,Y2,"Y")&"Years"&DATEDIF(X2,Y2,"YM")&"Months"

This function will cound Years with Months. Like 2Years3Months

[King Mak]

Hi. I tried also several times it was not working in MS Excel 2013, until I used semi columns instead of comas, in the formula's syntax. For the 2013 version, this is the only way. I almost broke my keyboard trying with comas but ....