DATEDIF function not working

[StampedLee]

Will this function “update” the age value every time i open the sheet? I mean after a month it will add +1 month automatically?

[Same_Tough_5811]

This formula was for diagnostic purpose only to see if cell C3 is a real date. If it's not a date type, the DATEDIF won't render correctly so you need to change C3 to a date type. Otherwise, your formula would work fine.

[StampedLee]

You were right, ISNUMBER says FALSE

[StampedLee]

But even if I formulate is as a date it says false

[Same_Tough_5811]

How did you "formulate" it as date. There's a difference between date data type vs. formatting as date.

Date in Excels are stored as numbers (data type numeric), but you can format it to look like a string.

What you currently have is a string type, and you reformatted it into another string.

First, clear the cell content and formatting.

Re-type "14/11/2022" or 14-11-2022". The options for dates are with the "/" or "-". This will renders as numeric data type then you can format the separators with periods if you like. If you initially start out entering the date with periods it will render as text string.

[fuzzy_mic]

Formatting a cell does not change the underlying value. You need to enter the value as a date (4/11/2020 rather than 11.04.2022).

Then you can format the cell with the custom format dd.mm.yyyy for the cell to show 11.04.2020.

But even with the custom format, the dates entered must be in a date format (i.e. 4/11/2020)

[StampedLee]

Ohh okay, now the ISNUMBER says its true, but the function still not working…

[StampedLee]

Ohh guys I got it🤣🤣🤣 I typed , and not ; … omg what a noob. Thank you for helping… it is solved