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

How to insert date in excel

July 25, 2022
6.3K Views

Excel is such a versatile system that it is often necessary to insert date in Excel to organize your calculations or projects better. Fortunately, there are several ways to add this element to your spreadsheet, all so simple that anyone can do it.

It is possible to insert date in Excel both statically and dynamically. Each alternative depends on the needs of each one. Luckily each method doesn't take too long to establish, so it's good that you follow these steps and experience a simple way to keep the date in order.

How to insert date in excel so that it remains static?

Achieving insert date in Excel with a static value inside the spreadsheet is very easy and will give you several advantages as a reliable guide for all your calculations. Here are some of the things you should do in your more traditional method in general:

1. Open your Excel file and click on a cell where you want to see the updated date.

2. When the cell is selected, press the combination of Crtl+; the current date will be added. This is a perfect shortcut for both Windows and Mac.

3. If you want to add the time, you can press Ctrl+Shift+; for Windows or Command +; on Mac devices.

How to add date dynamically?

Entering the date is not that complicated, but many do not want to complicate their lives and prefer it to be updated constantly. To insert date in excel online and make it more dynamic, you must follow these steps through the TODAY formula.

1. Enter Excel and click on the cell where you want to see the date.

2. Inside the cell, you must write the function =TODAY ().

3. Go back to the spreadsheet and notice how Excel will show the updated date. You can verify the next day that this element will remain changing depending on the day.

4. You can also insert date in Excel along with the time, although you will need to use the =NOW() formula instead.

How can you change the date format in Excel?

If you don't like the traditional format for dates very much and want to customize it, it is possible to achieve it. This way, you can be more comfortable when inserting dates in Excel and see even more benefits, so this is what you should do:

1. First, you need to insert date in Excel in the corresponding cell; click the right button and select Format cells in the menu when you are ready.

2. When the window appears, look for the Types  section on the right and choose the format that best suits your tastes.

3. Click on OK to save the changes, and you will notice how the date will be automatically displayed with the chosen format.

Regardless of the reason, working in Excel requires organization, so insert date in excel mac is quite useful for anyone. Getting a simple guide to insert date in Excel can make you better understand the functions of this tool and thus take advantage of its benefits twice.

It's time to download WPS Software and take advantage of this software's properties to enjoy creating documents in Word, PowerPoint, or Excel.

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