![What are the new functions in excel 2016](https://kumkoniak.com/6.jpg)
![what are the new functions in excel 2016 what are the new functions in excel 2016](https://images.saymedia-content.com/.image/t_share/MTc0NDgzODMzNzIxMjAyMzEw/how-to-use-the-vlookup-function-in-ms-excel-2016.png)
The answer (at the time I made this spreadsheet a few months ago) is 60 years, 11 months, and 3 days, and of course if I opened this spreadsheet today, it would be a longer time. If you want to find out exactly how old Whoopi Goldberg is today, enter her birthday () in cell A24, then enter this formula in cell E24: =DATEDIF(A24,TODAY(),”y”)&” years, “&DATEDIF(A24,TODAY(),”ym”) &” months, “&DATEDIF(A24,TODAY(),”md”)&” days”. And when you copy a hard-coded formula, you end up with the same date in each of the copied cells.Ģ. If the date is hard-coded into the formula, you have to open up and edit each formula one at a time.
![what are the new functions in excel 2016 what are the new functions in excel 2016](https://2.bp.blogspot.com/-kFAmnctItb4/VxbinCIi4kI/AAAAAAAARpA/oefD6cSsVGAa8uMH9cCjHL7S6cf3YKaLACLcB/s1600/Left%2Bfunction%2Bin%2BExcel%2B2016.jpg)
Note: Using cell references is always better than hard-coding the date into the formula like this: =DATEDIF(“3/15/11”, “12/7/16”, “d”), because you can easily change the date on the spreadsheet by just entering or copying a new date on top of the old one.
![what are the new functions in excel 2016 what are the new functions in excel 2016](https://i.ytimg.com/vi/09UzRAsy6xM/maxresdefault.jpg)
The answer is 5 years, 8 months, 22 days. For example, to get years, months, and days between Maand December 7, 2016, enter this formula using cell references instead of actual dates: =DATEDIF(A23,B23,”y”) &” years, “&DATEDIF(A23,B23,”ym”) &” months, “ &DATEDIF(A23,B23,”md”) &” days”. You can also nest the DATEDIF() function, combine it with other Excel functions such as TODAY() and NOW(), such as above, or nest it within itself to get all three arguments-the number of years, months, and days.
![What are the new functions in excel 2016](https://kumkoniak.com/6.jpg)