What is the purpose of the "DATE" function in Excel?
A. To count the number of days
B. To create a date from individual year, month, and day
C. To find the sum of a range
D. To find the average value
Answer (1)
The 'DATE' function in Excel creates a date from specified year, month, and day values, using the syntax DATE(year, month, day). It is useful for generating specific dates programmatically in spreadsheets. This function is crucial for accurate date handling in data management and analysis. ;
