This may give unexpected results when the day/month number of the second date is lower than the day/month number of the first date. To make the formula easier to work with, a persons birth date is entered into cell E1 of a worksheet (see the example below). One use for Excels DATEDIF function is to calculate a persons current age If you dont feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue. In the following formula, the DATEDIF function determines a persons current age in years, months and days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |