WPS Office

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.

Free download

Windows • MacOS • Linux • iOS • Android


How to Use Excel Date Formula

July 31, 2023

In daily life, we always need to calculate some number, such as keeping account and conducting data. There are multiple numbers of data types in excel, and Date is one of them. Therefore, while working or calculating dates in excel, one should know the Date function. To begin with, We can define the date function as the function that returns the sequential serial number representing a date.

What is Date Formula

Date Formula in Excel is very simple and easy to use. Let us now see how to use the Date Formula in Excel with the help of some examples. Date Formula in Excel is very simple and easy to use. Let us now see how to use the Date Formula in Excel with the help of some examples. These examples will surely help you with a clear understanding of the function.

Before discussing the Date() function examples, it is better to understand how Excel interprets the arguments given in the Date() function.

As mentioned earlier, the date range starts from 1/1/1900 to 31/12/9999. Hence, we will see how excel will interpret if we give year, month and date out of its range.

How to Use Excel Date Formula in Excel on Windows

Click Data

Click fx( )

Click Date and Time

Then choose the formula what you need and input the number.  The date will change according to the system after entering.  For example, Today function to enter the current date - type 4 Enter the formula function =today() in the cell where you want to enter the date to enter the current system date. Maximum feature: This date changes with the system date. Today it is 2018/11/4, and tomorrow it will be 2018/11/5.    

Finally you will get the result.

Learn More about How to Use Date Formula in Excel

Have you learned about how to date formula in excel? If you want to know more about Excel features, you can follow WPS Academy to learn.

You can also download WPS Office to edit Word, Excel, and PowerPoint for free. Get it now! And enjoy an easy working and studying experience.

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