Calc amount of days between dates [solved]

edit

Thank you, it seems to work! Another detail is that the destination cell, where the amount of days is calculated (C2 here), has to be formatted as number and not as date.

It is best to use the DATEDIF function

DATEDIF() is unnecessary.

#VALUE! happens if one of the operands is not a numeric date but text content.

DATEDIF() gives me Err:511 for the same dates that subtraction works for. Dropbox link

In Portuguese DATADIF, in English DATEDIF

"d" = Number of whole days between Start date and End date.

"m" = Number of whole months between Start date and End date.

"y" = Number of whole years between Start date and End date.

"ym" = Number of whole months when subtracting years from the difference of Start date and End date.

"md" = Number of whole days when subtracting years and months from the difference of Start date and End date.

"yd" = Number of whole days when subtracting years from the difference of Start date and End date.

I must be doing something else wrong, then, because I still get errors. Thanks for the interval information; I just found it in Help, too.

Actually, Help examples only show DATEDIF() used in formulas with the dates also in the formulas, not in other cells. I wonder if that's the issue. Can you only have DATEDIF("2020-03-01";"2020-02-01";"d") and not DATEDIF(A2;A1;"d") where A2 and A1 contain dates?

Maybe someone would kindly add a "datedif" tag to this thread? :)

@Inclement, example...

C:\fakepath\datedif.ods

Oh ack. I had the end date cell reference first like a dummy. Thank you, @Schiavinatto.

By the way, what I said up above is wrong, yes you can use cell references. It's too late to edit that out now.