Calculate Years Worked or Age Using the YEARFRAC Function

preview_player
Показать описание
Excel has many useful functions that help you calculate date or time differences. One of the time functions is the YEARFRAC function. This video show how to use the YEARFRAC function to determine years worked or a person's age based on a start date and an end date.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-
Рекомендации по теме
Комментарии
Автор

Thanks for the useful tip/trick for the benefit of Excel

gopalakrishnarao
Автор

But what if the years is less than a year... how to figure...

ovauskhan
Автор

Kindly please anyone solve this
Use the YEARFRAC function to work out how many years difference is there between the date 1980-07-31 (31 July 1980) and 1998-05-02 (2 May 1998) (to 1 decimal place)?


In 2017 the Islamic month of fasting, Ramadan, began on Friday, 26 May. What fraction of the year was this? (to 1 decimal place)

aliyascorpion
Автор

Hi, I am having such a hard time with this, I keep on getting 1/11900

andromeda