How to Use the YEARFRAC Function in WPS on Windows

This how-to guide includes 3 operation topics for YEARFRAC in WPS Sheets, with 3 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Enter YEARFRAC through the Insert Function dialog box

Entry point: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for YEARFRAC in the dialog box.
4. Select the function and click OK.
5. In the Function Arguments dialog box, enter the start date, end date, and optional basis argument.
6. Click OK to finish entering the function.

Success Criteria

• The cell now contains a YEARFRAC function.
• The result cell returns the fractional year value between the two dates.

Tips While Using

• The start date and end date should be valid date values.
• basis is optional. If you leave it blank, the default rule is used.

2. Type the YEARFRAC formula directly in a cell

Entry point: Cell or formula bar

1. Select the cell where you want to enter the formula.
2. Type =YEARFRAC(start_date,end_date,[basis]) directly.
3. Press Enter to confirm.
4. Check whether the referenced date cells are correct based on the returned result.

Success Criteria

• The formula returns a numeric result normally after entry.
• The formula bar shows the full YEARFRAC formula structure.

Tips While Using

• Use English commas as argument separators.
• If a date is stored as text, the result may return an error.

3. Review YEARFRAC syntax and argument details

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Search for and select YEARFRAC.
3. Review the function syntax: YEARFRAC(start_date, end_date, [basis]).
4. Confirm the purpose of each argument before completing the formula.

Success Criteria

• You can see the YEARFRAC syntax structure and argument positions.
• You can distinguish required arguments from the optional argument.

Tips While Using

• start_date and end_date should usually reference date cells or valid date results.
• Different basis values can change the returned result.