"DATEDIF" not available in my version of EXCEL. How to reinstate please.

Question

Trying to use "DATEDIF" function but not available EXCEL.

How can I reinstate this missing function?

Answer 1

Hi Andrew

I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. You can simply type =DATEDIF( in a cell to use it.

The above is as suggested by Sergei Baklan in the thread below

https://techcommunity.microsoft.com/t5/excel/office-365-excel-functions-datedif-and-xlookup-not-available/m-p/3600391

Learn more: https://support.microsoft.com/office/25dba1a4-2812-480b-84dd-8b32a451b35c

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

AnnaThomas

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Answer 2

As a side note, 365 tells me it's available as I type the word ...despite it not being in the list.

[Edit: Added 365 version per suggestion]

Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20002) 64-bit

Answer 3

Hi Anna,

I did this simple test: =DATEDIF(DATE(2023,1,1), DATE(2024,1,1), "m"). This should return 12 but I'm getting the below error. Could you please advise?

Note: I couldn't attach an image but the error is:

There's a problem with this formula.

Not trying to type a formula?

...