A planning sheet needs the share of a year represented by January 1 to April 1. Decide how the year is measured before pasting a decimal into the report.
Use real dates and state the basis
Put January 1, 2026 in A2 and April 1, 2026 in B2. If the planning rule is Actual/365, use:
=YEARFRAC(A2,B2,3)The basis value 3 uses actual elapsed days divided by 365. Put “Actual/365” beside the result so another reader can reproduce it.

Illustrated calendar interval. Use spreadsheet dates instead of formatted text.
Check the result from the day count
Subtract the dates to verify 90 elapsed days. Divide by 365 to get about 0.2466 years. Use the same basis across comparable rows. If the report specifies a different convention, check the appropriate basis before changing the formula.

Illustrated arithmetic check. Show the basis alongside the result.



