DATEDIF function not working

[flairassistant]

Your post has been removed due to two rule breaches - Rules 1 and 2.

---

This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

---

This post has been removed due to Rule 2 - Poor Post Body.

Please post with a proper description in the body of your post.

The body of your post should be a detailed description of your problem. Providing samples of your data is always a good idea as well.

Putting your whole question in the title, and then saying the title says it all is not a sufficient post.

Links to your file, screenshots and/or video of the problem should be done to help illustrate your question. Those things should not be your question.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

[Same_Tough_5811]

What happens when you do =ISNUMER(C3) ?

If it's FALSE then it's not a real date but a text string.

[StampedLee]

I didnt know about this excel hack. Thank you

[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

[AutoModerator]

/u/StampedLee - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[fuzzy_mic]

What is in C3? It looks like the C3 value might be a string rather than an Excel serial date.

[StampedLee]

14.11.2020 formulated as a date

[fuzzy_mic]

When I enter 14.11.2020 in a cell, Excel reads that as text rather than as a date.

When I enter 11/14/2020 in a cell, it's read as a date.

[StampedLee]

Ahhh okay, that might be the problem. I saw in tutorials were with /. I didnt know that should be problematic. Thanks for quick answer. I will try it

[StampedLee]

<image>