In this video, I will show you how to calculate age in Excel in Years, Months, and Days (when you have the date of Birth).

This can easily be done using the DATEDIF function, which is a legacy function and is made available for compatibility reasons with LOTUS 123.

With Datedif you can calculate:
-- Total years that have passed in between the date of birth and current date
-- Total number of months that have passed in between the date of birth and current date
-- Total number of days that have passed in between the date of birth and current date

You can also read more about this here: [ Ссылка ]


Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]

⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

свернуть