# Yearfrac problem

#### EleanorSykes1989

##### New Member
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

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### steve the fish

##### Well-known Member
You could use:

=(B1-A1+1)/365

or

=YEARFRAC(A1,B1+1,3)

if you want both the date to be inclusive.

#### footoo

##### Well-known Member
Use : =YEARFRAC(A1-1,B1,3)

Or : =(B1-A1+1)/365

#### EleanorSykes1989

##### New Member
That's great thanks

Replies
8
Views
374
Replies
7
Views
55
Replies
17
Views
2K
Replies
1
Views
347
Replies
1
Views
56

Threads
1,127,098
Messages
5,622,679
Members
415,921
Latest member
ExcelNoob28

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back