How to convert excel dates into decimal dates

I have found three methods to convert excels dates into decimal dates where the year is represented by the whole number and the months and days are represented by everything after the decimal place as a fraction of a year.
Method 1=(date/365.25)+1900
Method 2=year+(month/12)-(1/12)+(day/365.25)
Method 3=YEARFRAC(date,0,1)+1900
---------------------------------------------------------------------------------
#exceltutorials #exceltipsandtricks #excelformulas

VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:

[mariaczarnecka]

Thank you, that is very helpful and well explained. I used the first method. Could you just confirm for me, what would be the formula to do the opposite (convert from a decimal to the usual format date)?

[QuinYouTube]

This is the best way I have found: (If you have a date in A1) =YEARFRAC(DATE(YEAR(A1), 1, 1), A1, 1)+YEAR(A1)

[baatrmandzhiev]

Thank you, really interesting methods. I will use them

[Aparna_Yadav]

For other years which are not a leap year then, why are we dividing every date by 365.25?