TODAY in WPS on Windows FAQ

This FAQ covers 4 common questions about entering the TODAY function, refreshing results, and combining it with other formulas, plus 4 glossary terms.

FAQ

What should I do if the TODAY function shows an error?

1. Check that the formula starts with =.
2. Make sure the function name is spelled TODAY and includes one pair of parentheses.
3. Remove any extra arguments and re-enter =TODAY().
4. Press Enter again to confirm the result.

Why is the TODAY result not updating?

1. Confirm that the Windows system date is correct.
2. Reopen the worksheet or edit any cell to trigger recalculation.
3. Press F9 to recalculate manually.
4. Check the TODAY-based result again.

Which functions can I use with TODAY?

1. You can combine it with date functions such as YEAR, MONTH, and DAY.
2. You can also use subtraction to calculate the number of days from another date.
3. For period analysis, you can nest TODAY inside other date formulas.
4. Check that referenced cells contain valid date values.

What is the difference between TODAY and NOW?

1. TODAY returns the current date.
2. NOW usually returns the current date and time.
3. If you only need the date, use TODAY.
4. If you need both date and time, use a function that includes time.

Glossary