WHAT IS DATE FUNCTION IN MICROSOFT EXCEL?
In Microsoft Excel, DATE function helps to return date value by using day, month and year values from different cells. Date function in Microsoft Excel is more powerful function, and this function is categorized under Date and Time functions.
SYNTAX FOR DATE FUNCTION IN MICROSOFT EXCEL
Date function required 3 functional arguments
=DATE (YEAR, MONTH, DAY)
— Year, Month, Day values should be integers and all are required arguments
— Year value should be between 1900 to 9999
— Month value should be between 1 to 12
— Day value should be between 1 to 31
(check out the below video to learn more about Date function in Microsoft Excel)
EXAMPLES OF USAGE DATE FUNCTION IN MICROSOFT EXCEL
Practice the below examples and try with different values to learn and play with DATE function
|1||Enter the values in cells (A2 – value 2020, A3- value 3, A4 – value 28). In cell A5 write formula||=DATE(A2,A3,A4)||3/28/2020|
|2||Select above A2, A3 cell values for year, month. For day value instead of selecting cell A4 value, just type 1 in formula.||=DATE(A2,A3,1)||3/1/2020|
|3||Use the same values in first row ( A2, A3, A4) and write formula||=DATE(A2,A4,A3)||5/3/2022|
|4||For dynamically returning the first day of month , write formula in cell A1 (Assume today’s date is 28th March 2020)||=DATE(year(today()),month(today()),1)||3/1/2020|
|5||For dynamically returning the first day of next month , write formula in cell A1 (Assume today’s date is 28th March 2020)||=DATE(year(today()),month(today())+1,1)||4/1/2020|
If you observed the third example, we have selected month value in day argument, and day value in month argument. Date function returns the value with out any error, but actually we need to select the values like in the first example.
NOTE: So be cautious about selecting valid arguments, otherwise will get incorrect result
TIPS & TRICKS:
- As shown in the above fourth and fifth examples, we can use date function for dynamically returning values based on your needs.
- We can mix for one or two cell values as arguments, and we can mix with static values to return the date value in cell
- Especially, Date function is more useful for returning automatic date values in creating templates, automatic reports, project planning, accounting, data and business analysis etc.