Use the Today function to quickly calculate days between dates

Uploaded time: 2021-08-27 Difficulty: Primary

Use the Today function to quickly calculate days between dates

Use the Today function to quickly calculate days between dates

Graphic skills

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. 

001.gif 

In addition, we can also use the Today function to calculate the number of 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. 002.gif


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.