Quote:
Originally Posted by wsnow
Okay, you HAVE to explain to me why that worked!!!!  |
It's better to explain why your formula didn't work!
MONTH(3) returns the month of date 1/3/1900 (i.e. 1, as it will be January);
DAY(31) returns the day of date 1/31/1900.
The syntax of DATE() function is:
DATE(YearNumber, MonthNumber, DayNumber)