Тёмный

How To Calculate Age In Excel | Datedif Alternative | Age Calculator 

Brain Behind Business
Подписаться 11 тыс.
Просмотров 2,6 тыс.
50% 1

In this video, I will teach you How To Calculate Age In Excel From A Date Of Birth using a datedif alternative which is normally not available in all Excel versions.
To use this formula you would need the date of birth and today's date using today formula or you can write it manually as well.
0:00 Intro
0:15 Datedif alternative
0:40 Today Formula in Excel { today() }
1:05 Rounddown formula in excel to make Age Calculator
2:27 End Screen
#Excel #ExcelTutorial #ExcelForBeginners

Опубликовано:

 

19 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@andyjackin5128
@andyjackin5128 2 года назад
This is very helpful👍 I'll be looking for more alternatives like this
@BrainBehindBusiness
@BrainBehindBusiness 2 года назад
Glad it was helpful!🙏 Stay connected, I have so much to share ✨
@HeaDShotHNb
@HeaDShotHNb Год назад
What if i wanted to get the months of two dates
@BrainBehindBusiness
@BrainBehindBusiness Год назад
Its pretty easy. you can use this simple formula =(ending date-start date)/30 you will get that example (03/aug/2022 - 01/Jan/2022) / 30 Try this and let me know your feedback
Далее
How to Calculate Hijri Age In Excel (mac & windows)
11:56
Must-have gadget for every toilet! 🤩 #gadget
00:27
The right decision came to mind #comedy
00:12
Просмотров 475 тыс.
Using the Top Secret DATEDIF Function in Excel
5:42
Просмотров 46 тыс.
Calculate Age from date of birth in Excel
0:25
Просмотров 391 тыс.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
How do I calculate someone's age in C#
5:13
Просмотров 13 тыс.
Separate Text and Numbers in Excel (4 Easy Ways)
16:13
Просмотров 249 тыс.