Question 1 of 10
For example, to return the date February 5th, 2012 type the following formula:
=DATE(2012, 2, 5)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
DATE Function - Free Excel Practice Online
This free, interactive exercise teaches you DATE Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Date Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising DATE Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this DATE Function lesson
- The DATE function in Excel takes three number arguments (year, month, and day) and combines them to return a date. You can remember the order of the arguments because they go from largest unit to smallest.For example, to return the date February 5th, 2012 type the following formula:=DATE(2012, 2, 5)
- Now use the date function to return January 15th, 2012.
- Use the numbers in the cells below to return the date.
- Use the numbers in the cells below to return the date.
- Use the numbers in the cells below to return the date July 3rd, 2000.
- Use the numbers in the cells below to return the date August 2nd, 2001.
- Use the numbers in the cells below to return the date July 4th, 2005.
- Write a DATE formula that returns January 1st, 2001.
- Write a DATE formula that returns December 10th, 2010.
- Write a DATE formula that returns March 15th, 2020.
DATE Function practice - FAQ
How do I practice DATE Function in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the DATE Function exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this DATE Function lesson?
This lesson covers DATE Function as part of the Date Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.