DATEDIF not working.

[Camel123]

Hi,

Trying to retrieve the number of months between the two dates below. Dates are generated through functions beneath.

2019-01-01
A1=DATEVALUE(YEAR(TODAY())&"-01")

2019-04-01
B1=EDATE(DATEVALUE(MID($C$12;18;4)&"-"&MID($C$12;23;2));1)


=DATEDIF(A1;B1;"M") does not work, returns "1900-01-03" but should return "3" (jan+feb+mar). Cell references are formatted as dates. If dates are not derived from functions then the DATEDIF returns "3".

Any suggestions on how to solve this?

 

[Joe4]

Re: Help, DATEDIF not working.

=DATEDIF(A1;B1;"M") does not work, returns "1900-01-03" but should return "3" (jan+feb+mar).

It looks like it is working. "1900-01-03" is actually 3. Just change the format of that cell from Date to General.
Note that Excel stores dates as numbers, specifically the number of days since "1900-01-00".
So dates are really just numbers with custom date formats.

 

[Camel123]

Re: Help, DATEDIF not working.

It looks like it is working. "1900-01-03" is actually 3. Just change the format of that cell from Date to General.
Note that Excel stores dates as numbers, specifically the number of days since "1900-01-00".
So dates are really just numbers with custom date formats.

Did not even notice haha but... Woho, it worked haha! Thank you :D

 

[Joe4]

Re: Help, DATEDIF not working.

You are welcome!