AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.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.
Alternatively, use the function to compute the difference between any two dates. In the following formula, the DATEDIF function determines a persons current age in years, months and days. The cell reference to this location is entered into the formula. If the birth date is stored in a different cell in the worksheet, the three cell references in the formula need to be changed. The formula uses DATEDIF three times to calculate first the number of years, then the number of months, and then the number of days between the two dates. Number of Years: DATEDIF(E1,TODAY(),Y) Years, Number of Months: DATEDIF(E1,TODAY(),YM) Months, Number of Days: DATEDIF(E1,TODAY(),MD) Days. One use for concatenation is to join number data and text data together when used in a single formula. For example, the ampersand joins the DATEDIF function to the text Years, Months, and Days in the three sections of the formula. ![]() Use Dates In Excel For Every Datapoint Serial Date ToSince the TODAY() function uses the computers serial date to find the current date, the function continually updates every time a worksheet is recalculated. The persons current age increases when the worksheet is opened unless automatic recalculation is turned off. ![]()
0 Comments
read more
Leave a Reply. |