Excel Guides

Entering Dates in Excel

There are a few different ways to enter dates in Excel. The most common way is to simply enter the date in mm/dd/yyyy format. For example, if you wanted to enter the date January 1, 2020, you would simply type 01/01/2020 into a cell. You can also use the DATE function to enter a date in yyyy-mm-dd format. For example, if you wanted to enter the date January 1, 2020, you would type =DATE(2020,1,1) into a cell.

If you want to enter a date and time value, you can use the TIME function. For example, if you wanted to enter the time 3:00 PM on January 1, 2020, you would type =TIME(15,0,0) into a cell. You can also use the NOW function to enter the current date and time. For example, if you wanted to enter the current date and time, you would type =NOW() into a cell.

If you want to format a date value in a specific way, you can use the TEXT function. For example, if you wanted to format the date January 1, 2020 as "January 01, 2020", you would type =TEXT(DATE(2020,1,1),"mmmm dd, yyyy") into a cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.