Calculate Age Using DATEDIF Formula in
Автор: Rachana Chiv
Загружено: 2024-06-27
Просмотров: 3498
Описание:
How to Calculate Age Using the DATEDIF Function in Microsoft Excel.
In this video, I use the DATEDIF Function to calculate age of Employees in Microsoft Excel.
What is the DATEDIF Function in Microsoft Excel?
DATEDIF is a function in Excel that calculates the difference between two dates. It can return the difference in years, months, or days, making it useful for tasks like age calculation, duration of projects, and time intervals.
Syntax:
DATEDIF(start_date, end_date, unit)
start_date: The start date in a valid date format.
end_date: The end date in a valid date format.
unit: A text string that specifies the type of information you want returned.
Formula in this video:
=DATEDIF(B3,TODAY(),"y")
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
💕💕♥️📖
------------------------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #knowledge #knowledgesharing #exceleducation
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: