How to Set the Date Using Excel Date Formula

WPS office is a suite which gives access to all the tools at one place. It is available to download for Windows, Linux, Mac, iOS, and also for Android at free of cost. 

Here you will get all the spreadsheets in xls, xlsx formats and it is the best alternatives which you can find in the market to MicroSoft Excel. WPS office is now the fav all in one software solution for more than 500 million users from more than 200 countries. Here we are going to discuss how to use the excel date formula because when you calculate dates in excel and not sure how to do it. This excel date formula will come to rescue you, it is the most important function in excel to understand. 

Excel Date Formula 

Excel function for date returns a serial data if you put some date. This formula is categorised as Date/Time Function. It is basically used as a worksheet function(WS). It is quite easy to use date and time. Suppose cell A1 contains the current date entry 9/01/2023, then if you want to know 100 days after the date, then you can easily use the formula =A1+100. 

Formula  :  = DATE(Year,Month,Date)

E.g –  = DATE(2013,05,29)

Syntax of Excel Date Formula

DATE (Year, Month, Day)

Year – It represents the year which you want to store.

Month – It represents the no. of month.

Day – It represents the no. of day in a month which you want to store.

Year – Here excel will interpret the year based on the date system set on your PC/Laptop. In windows, by default 1900 date system is used which means if January 1, 1900 is represented as serial number 1. Suppose you have given a year between 1900 and 9999, excel will use exactly the same value which you will give to it. E.g , Date(2023,01,09)  will return the value January 9th, 2023.

Month – If you add a month digit which is greater than 12, then excel will add the extra number to the first month in the specified year. E.g Date(2015, 15, 05) will return the value March 1, 2016.  

Day – Here we can feed dates as negative or as positive no. and excel will be able to calculate its value based on the same principle discussed above.

Know About Date Formula in Excel

If you gain enough insight about Excel Date formula then it will be easy for you to work fastly and efficiently for your school projects, business ideas or any other documentation. WPS will give you full access to all the tools at a very nominal cost as compared to pricey softwares in the market. 

The best thing about WPS office is that it is compatible with all the operating systems which includes Mac, iOs, Linux, Android. It is very easy to install WPS software on your PC. You just need to visit its official website and click download on the display of your system. After that you will have a zip file which will contain a link to download and install WPS. Now you can get the membership for free and start editing your sheets or pdfs and many more. Once you have downloaded it then you are good to go and all set to make your life a little more comfortable.

If you like this article, please share it with your friends

Leave a Reply

Your email address will not be published. Required fields are marked *