Excel to calculate age DATEDIF Formula | Calculate Experience in Excel one line formula |Excel Formula | Excel Function exceldesk.in/2019/11/Datedif-calculate-experience-in-excel-using.html
Calculate Experience in Excel Using Excel Formula DATEDIF (excel to calculate age) DATEDIF Function Calculate Given Date of Period. For Calculation Age, Experience, Period between 2 Dates,Dated if formula help for period calculation.
Ex. In the following Image we can see Employee Name Date of joining & in the last column D count their Experience. Let's Learn Step by Step DATEDIF Formula. Use 3 Extra column after Experience. We firstly we are calculate separate Year, Month & Days. To Apply DATEDIF Formula we Start Date, End Date & Year or Month or Day what we want. =DATEDIF(start date,End date,"Y") Use following short content. 1/6
Year = "Y" Month = "YM" Day = "MD" Here Start Date is DOJ in C column. End date is present date means we can use TODAY() formula. Using TODAY() Formula need not update experience time to time. It will auto Update Day to day according your computer Date. In the Cell E4 Type =DATEDIF( Select Starting Date cell C4 then press Comma Then Type TODAY() Press Comma (,) Then calculate Only Years Type "Years" (Don't Forget Type Text in inverted comma "") Then Enter. =DATEDIF(C4,TODAY(),"Y") We are getting Year From joining to till date.
Repeat Process in the Cell F4 =DATEDIF(C4,TODAY(),"YM") We will Getting Months of Over Year.
2/6
Repeat Process in the Cell G4 =DATEDIF(C4,TODAY(),"MD") We will Getting Days Over Year & Months
We are found Year, Month & Day in Separate Cell. Now We are Marge in one cell with some Text. 3/6
Click on cell E4 & Press F2 Select formula & Copy it press escape Button.
Click on the cell D4 Press F2 & Paste the formula. type &" Years " =DATEDIF(C4,TODAY(),"YM")&" Years " Press Enter Enter
Remember = sign use only start of the formula Between two formulas & Text use always & sign
4/6
Press & Repeat Process for Month & Day with Changing Text according formula. Our Complete formula is =DATEDIF(C4,TODAY(),"Y")&" Year's "&DATEDIF(C4,TODAY(),"YM")&" Month's "&DATEDIF(C4,TODAY(),"MD")&" Day's"
You can copy above formula & paste in your sheet.
Finally we are found Total Experience in One cell. Copy formula then Paste in the Cell below.
5/6
Click here to Download Formula Workbook excel to calculate age Make sure for apply this formula your date format is DD-MMM-YY (Not Recommended)
6/6