DATE function

This function will convert a day, month and year to a serial number that Excel uses for date values.

Syntax

DATE(Year, Month, Day)

  • Year (required) – This is the year number from 1900 to 9999.
  • Month (required) – This is the month number from 1 to 12.
  • Day (required) – This is the day number from 1 to 31.

Example

In this example we create a few dates by reference to a year, month and day. Notice that if we use a month greater than 12 or a day greater than the actual number of days in the month, then the result rolls over into the next month or year.

=DATE(A2,B2,C2)

DATE

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

Related Posts

DAYS function

This function will allow you to find the number of days between two dates....

read more

DAY function

This function will take a date in any format and return the day as an integer...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃