WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Create a countdown calendar & Insert current time and date

Uploaded time: September 30, 2021 Difficulty Intermediate

Create a countdown calendar & Insert current time and date

Create a countdown calendar & Insert current time and date

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it.

· 1.TODAY function

To quickly insert the current date in the table, click cell B5, enter =TODAY (). Then press Enter to enter the current date.

Every time the table is reopened, the current date will be refreshed. If it is not refreshed, press F9 to refresh manually.

· 2.NOW function

To enter the current time and date, enter =NOW(). Then press Enter. Each time the table is reopened, the current time will be refreshed, or we can press F9 to refresh manually.

· 3. DATEDIF function

If we want to make a countdown calendar, we can use the DATEDIF function.For example, now we want to calculate how many days are left until the final exam. Click cell D21 and enter =DATEDIF (TODAY(),C22,D).

There are three parameters in this formula, namely:

Start date, End date and Comparision Unit.

Since we need to calculate how many days are left until the final exam, the Start Date should be the current date. Therefore, we need to enter the TODAY() function.End date is the date of the final exam. So here, we select C22.Comparision Unit is Day, and “D” represents the day.

To learn more about the specific usage of the DATEDIF function, you are welcome to join our WPS Academy to watch more related videos.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.