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 add dates in excel automatically

February 13, 2023

You may need to learn how to add dates in excel because it is something that is being required of you at work. If that is your case, you should know that the process of how to add dates in Excel is simple as long as you get carried away by some methods. It is time for you to know how to add dates in Excel by applying a series of basic steps.

The whole process of how to add dates in excel Mac will also work on your Windows computer for you to apply it smoothly. It is good that you take your time learning this tool and try to get the most out of it.

How to add today's date in Excel?

If you are looking for a method that will not take you 5 minutes to learn how to add dates in Excel, you should do the following:

1. You will only have to open the Excel document where you want to add the current date and time.

2. Select the cell where the data will appear and write down the date, which could be contained in various formats. Generally, you will see dates by the first day of the week, month, and the last two digits of the year.

3. In case Excel does not recognize the date format, you will have the option of adding it through its tools. You only have to go to the home tab and then open the general box. In this option, you will see the option to organize the data by long or short measure.

How to add the current date in Excel as a mark?

You could also learn how to add dates in excel Online, but this time using it as an immutable flag. For you to fulfill this purpose in the integration of the data in Excel, you must do the following:

1. Open the Excel document where you want to put the current date as an immutable mark. This means the document will have a date that cannot be edited after creating it.

2. Go to the function option and enter the following formula: =IF(B2= yes,IF(C3=,NOW(), C3),). You can also change the number of cells at your convenience.

3. After indicating the formula in Excel, you only have to click on enter and save changes. It is good to know that for the formula to work, you must have the iterative calculations option in Excel.

How to add the current date in Excel with a daily increment?

Finally, you can try to know how to add dates in excel 2019 with a daily increase to rewrite it as many times as you want. If you want to be successful in this method, you must:

1. Open the Excel document and enter the starting date in the desired cell; cell A1 will be used in this case.

2. Now, you will have to click on the cell with the first date and then drag it to the cells below it.

3. Select all the cells with the date and click on autocomplete options, which would be at the end of the last cell. Within this box, several favorable options will appear; you will only have to choose the most profitable.

Keeping in mind how to add dates in excel 2016 will be very useful if you are in charge of organizing data in your company. You should not ignore these methods knowing that they are the most accurate for you to add a current date in Excel.

It would help if you also went to the website to download WPS Office without investing a single penny of your money.

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