datedif() arguments

[lezawang]

Hi
I want to understand datedif() function. What I do not understand the logic behind "Y", "YM", MD"
Why YM to find month, why not only M? and why MD to find day? why not D same as Y for year. I do not understand the logic behind YM and MD? Thank you so much

= datediff(A1,today(),"Y") - to calculate year
= datedif(A1,today(),"ym") - to calculate months
= datedif(A1,today(), "MD") - to calculate days

 

[Fluff]

Have a look here
https://exceljet.net/excel-functions/excel-datedif-function

 

[Peter_SSs]

Legend Chip Pearson also has some good information on DATEDIF
http://www.cpearson.com/excel/datedif.aspx