{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nCalculate the Difference Between Two Dates in Excel\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nThis video tutorial demonstrates how to calculate someone's age from their date of birth in Microsoft Excel using the Date DIF formula and the NOW function. By inputting the individual's date of birth and the current date, the formula...\nThis video tutorial demonstrates how to calculate someone's age from their date of birth in Microsoft Excel using the Date DIF formula and the NOW function. By inputting the individual's date of birth and the current date, the formula automatically calculates their age in years. This efficient method allows for easy updating and provides a quick overview of the ages of multiple individuals in a spreadsheet.\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
5:45
\n
\n
\n
\n
\n
Grade
Pre-K - Higher Ed
\n
\n
\n
\n
\n
Subjects
STEM
7 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nThe Tech Train\n\n
\n
\n
\n
\n
\n
Date
\n
2015
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Concepts

\n
\n
time, birth, years, work, microsoft excel
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
microsoft, excel, datedif, date difference, calculate age, speech marks, date diff, current date, starting, current, date, person, working, equals, click, brackets, formula, column, spreadsheet, people, names, dates, show, calculate, part, difference, dated, function, open
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: Calculate the Difference Between Two Dates in Excel\" href=\"/subscription/new\">\"Calculate\n\n
\n
\n
\n\n\n\n"}