DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas for Converting Days to Years, Months, and Days!!

#excelformula #excelformulas

Formulas for Converting Days to Years, Months, and Days in Excel:

This page shows the formulas for Converting Days to Years, Months, and Days in Excel Office 365. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formula Syntax:

  • To Convert Days to Years, Months, and Days in Excel Office 365, use the below formula.

=DATEDIF(0,B3,”y”)&”years”&DATEDIF(0,B3,”ym”)&”months”&DATEDIF(0,B3,”md”)&”days”

Example:

  • In the below screenshot, we give the input days in Column B.
  • After applying the formula, it will display the results in the selected cell as shown in the image.

Syntax Explanations:

DATEIF Function:

  • DATEDIF – In Excel, the DATEDIF Function is used to returns the calculated difference between two dates.

Example:

  • In the below screenshot, the input values Start_date and End_date are given in Cell C5 & E5.
  • Then enter the following formula to get the output of difference in years. 
**=DATEDIF(C5,E5,"Y")**
Enter fullscreen mode Exit fullscreen mode

DATEDIF function in Excel
DATEDIF Function in Excel

  • After applying the formula, the output will be displayed in the selected Cell G5 as shown in the below image.

Example 1 - Output
Example – Output

Closure:

In this article, you can understand how to Convert Days to Years, Months, and Days using Formula in Excel Office 365. If you have any suggestions, leave it in the below comment box. Thanks for visiting Geek Excel!! Keep Learning!!

Read also:

Top comments (0)