Question: how do i calculate years and months from today in excel?
Answer: DATEDIF(B2,TODAY(),"md") & "d" denotes days between dates, ignoring months and years with string “d” attached to the number. As you can see their age now. You can use this function to calculate the number of days in service in Excel.