Yearfrac problem

EleanorSykes1989

New Member
Joined
Aug 7, 2017
Messages
16
Hi all,

I'm using the YEARFRAC function to calculate the fraction of the year worked. Based on 13/5/2019 - 31/07/2019 the function returns
0.2166666667.

<colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <tbody> </tbody>
However based on calendar days 80/35= I get 0.219780219.

Think my formula only including days inbetween the 2 dates? And also I have read that the function bases the YEAR around 360 days an not 365.

Is there a better way to calculate please?

Give the calc is linked to bonus I need this to be right.

Thanks
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,718
Office Version
365
Platform
Windows
You could use:

=(B1-A1+1)/365

or

=YEARFRAC(A1,B1+1,3)

if you want both the date to be inclusive.
 

Forum statistics

Threads
1,077,917
Messages
5,337,163
Members
399,129
Latest member
ericosman

Some videos you may like

This Week's Hot Topics

Top