Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Use the Today function to quickly calculate days between dates
Uploaded time: August 27, 2021 Difficulty Beginner
Use the Today function to quickly calculate days between dates
Use the Today function to quickly calculate days between dates
In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation?
First, I will teach you how to use Today function to calculate days between the current date and the future date.
If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are about to expire, allowing you to prepare for renewals in advance. It is known that today is August 13th, so what should we do?
1. Click cell C2 and enter =B2-Today () in the upper formula bar. B2-Today () refers to the contract expiration date minus the current date.
2. Click the Enter key on the keyboard, and then we can calculate days between dates.
In addition, we can also use the Today function to calculate the numberof days between the current date and the event that has occurred.
It is known that today is August 13th, and the openning ceremony of the Beijing Olympics was on August 8th, 2008.
1. Click D3 and enter =Today()-C3 in the upper formula bar. Today-C3 refers to the current date minus the start date.
2. Click the Enter key on the keyboard, and then we can calculate days between dates.
Even if we haven't opened the file for a few days, we can use the shortcut key Ctrl+Alt+F5 to refresh the interval days in real time.
To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Also Read:
- 1. SUBTOTAL function: Calculate the data with the hidden value
- 2. Use SUM function to quickly calculate the sum
- 3. Use the DATEDIF function to calculate the intervals of dates
- 4. Quick to learn the time and dates functions
- 5. Use the ROUND function to round decimals quickly
- 6. Use the cross-reference function to quickly jump
Does this video help you?