Age was calculated by YEARFRAC function in Excel #shorts #excel #excelbasic

Using the YEARFRAC Function to Calculate Age in Microsoft Excel.

In this video, I use the YEARFRAC Function to Calculate Age in Microsoft Excel.

What is the YEARFRAC Function in Microsoft Excel?

The YEARFRAC function calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). For instance, you can use YEARFRAC to identify the proportion of a whole year's benefits, or obligations to assign to a specific term.

Syntax:
YEARFRAC(start_date, end_date, [basis])
Start_date (Required): A date that represents the start date.
End_date (Required): A date that represents the end date.
Basis (Optional): The type of day count basis to use.

Formula in this video:
=YEARFRAC(B3,TODAY())

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 #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge #excelclub #newexcel
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv