DATE function
Summary
Returns the serial number of a particular date
Syntax
DATE(year,month,day)
Example
=DATE(C2,A2,B2) combines the year from cell C2, the month from cell A2, and the day from cell B2 and puts them into one cell as a date. The example below shows the final result in cell D2.
Need to insert dates without a formula? No problem. You can insert the current date and time in a cell, or you can insert a date that gets updated. You can also fill data automatically in worksheet cells.
Change the date format
On the Home tab in the Number section select ether Long Date or Short Date.
Alternatively, right-click the cell(s) you want to change and select Format cells or press Ctrl+1. On a Mac, Ctrl-click the cells (Command+1 on a Mac).
Select Date from the Category menu.
3. Choose the Locale (location)
Need to insert dates without a formula? No problem. You can insert the current date and time in a cell, or you can insert a date that gets updated. You can also fill data automatically in worksheet cells.
Change the date format
On the Home tab in the Number section select ether Long Date or Short Date.
Alternatively, right-click the cell(s) you want to change and select Format cells or press Ctrl+1. On a Mac, Ctrl-click the cells (Command+1 on a Mac).
Select Date from the Category menu.
3. Choose the Locale (location)