I want to calculate the difrence between old date and now in months. MS has examples of datedif() but another website says that datedif is depreciated and no longer used. Replaced by YEARFRAC()



Confused.
=DATEDIF(2023/1/1,2024/1/1,"M") = 0

You need to add double quotes when you do not reference cells Excel DATEDIF function | Exceljet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Or use DATESERIAL() - the formula will work with any local setting then

Putting =DATEDIF(DATESERIAL(2023,1,1),DATESERIAL(2024,1,1) ,"M") into a cell gives me #NAME?

Did you try PecoFlyer's suggestion. His solution works for me.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505

Microsoft is saying the function is DATEDIFF()!

Where did you get that ? DATEDIF function - Microsoft Support

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

DATESERIAL is an ACCESS or VBA function. DATEDIF ( with one "F") is the way to go ( among others)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sorry! Somehow forgot, that the post wasn't about programming!
So
And why can't MS have unified naming conventions? The functions with identical names do something different, the functions which do the same thing, are named differently! Very confusing!

Perhaps to avoid confusion as the DATEDIFF and the DATEDIF ( not supported by MS anymore) functions have very different syntaxes?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

@Pablo2000 As all this helped? You did not react anymore?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post