Calculating Age in Excel

preview_player
Показать описание
Use Microsoft Excel to calculate a person's age based on their birth date.
  1. UK HR Training and Development
  2. Microsoft Excel
  3. Age
Рекомендации по теме
How to Calculate 0:03:09

How to Calculate Age Using a Date of Birth in Excel (The Easy Way)

How To Calculate 0:03:10

How To Calculate Age In Excel From A Date Of Birth? | Excel Tutorials For Beginners | Simplilearn

How to Calculate 0:03:32

How to Calculate Age from Date of Birth in MS Excel (Year, Month, Day)

Calculate Age with 0:02:41

Calculate Age with EXCEL formula - 2 minute Excel formula

How to Calculate 0:05:10

How to Calculate Age in Excel from Date of Birth or Specific Date | Age in Years and Months

Calculate Age in 0:05:11

Calculate Age in Years, Months and Days in Excel

How To Calculate 0:08:06

How To Calculate Age From Date of Birth In Excel

Calculating Age Groups 0:04:40

Calculating Age Groups

How to calculate 0:00:41

How to calculate age by date of birth in #excel | Excel me age kaise calculate kare #exceltips

How To Calculate 0:04:22

How To Calculate Age from Date of Birth in MS Excel | Age Calculator in Excel

Calculate Age in 0:01:00

Calculate Age in Excel from Date of Birth | Simple Formula #Shorts

How to Calculate 0:04:02

How to Calculate Age Using Date of Birth in Excel

Calculating Age 0:03:08

Calculating Age

AGING FORMULA | 0:00:48

AGING FORMULA | DATE FUNCTION

Calculate Age in 0:01:00

Calculate Age in Excel | #Shorts #EdBharat #Excel

How to calculate 0:00:17

How to calculate Age in Excel? (DATEDIF function) | Calculate age from Date of Birth #shorts #excel

How to Calculate 0:01:07

How to Calculate Age of Person in Excel

How to calculate 0:04:48

How to calculate age in Excel (as of today or on a specific date 📆)

Calculating Age in 0:04:24

Calculating Age in Excel

How to Calculate 0:01:33

How to Calculate Age Using a Date of Birth in Excel | Excel Tutorials for Beginners

How to Calculate 0:03:30

How to Calculate Ages in Excel

How to Insert 0:00:56

How to Insert Current Age Automatically in Excel using a Simple Formula --Quickly and accurately

Excel 101 #1: 0:01:57

Excel 101 #1: Get Age #VALUE! Error (Solved)

How to Calculate 0:01:30

How to Calculate Age using Microsoft Excel

Комментарии
Автор

Couple of questions - 1st / I've already typed the age of each individual into my spreadsheet - what I would like to do is add there birthdates (not visible) so that the age will automatically update whenever I open the spreadsheet. 2nd / In your presentation are the formulas visible in columns J, K, & L ?? Thanks

mikewilson
Автор

Just use the TODAY function and DATEDIF together to get the right age.

mchllwoods
Автор

Hello! I need help! There isn’t any videos explaining how to calculate Gestational Age? I need to calculate the gestational age in weeks and days on today’s date. How can I do this?

titilore
Автор

Easier with one formula:

=DATEDIF(C2, NOW(), "y")

C2 being the D.O.B

moneebalbanna
Автор

Hi. Thank you for the video. I was wondering if there's a way to show only the age and not columns K thru M. THank you again

burns
Автор

Hi that was nice and thanks for the INT function.
BTW ROUNDDOWN would also give the same results i guess.

jamesperry
Автор

Thanks for watching burns83! You can hide any columns you'd prefer not to see, by 1) highlighting the column(s), 2) right clicking on the selected column(s), and 3) choosing "Hide" from the right-click menu.

ukhrTandD