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.

January 1 to April 1, 2026 spans 90 elapsed days.

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.

Actual/365 divides 90 by 365 to give approximately 0.2466 years.

Illustrated arithmetic check. Show the basis alongside the result.

Microsoft’s YEARFRAC basis reference