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
<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
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. |
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