Syntax of DATE Formula Example of DATE Formula Possible Errors returned by the DATE Formula DATE formula in Excel returns the number representing the date for a given day, month and year.

Again, just like the month parameter mentioned above, the day is not limited to numbers lying between 1 and 31 but can be any number (negative or positive) till such time that the minimum and maximum limits for the date, as mentioned above, are not breached.

For Example if you were to write a date function as =DATE(2009,4,35) it would give you a date 35 days ahead of 1-Apr-2009. Similarly you could use a negative number generate a date in the past.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

Why that worked, I have no idea, but if you run into a similar problem, maybe it will help you too.

Of course, this solution could stop working again, at the next lunar eclipse!

We tried using the Calculation shortcuts, including Ctrl Alt Shift F9 (that one recalculates everything, and starts your car).

However, none of the shortcuts had any effect on the non-calculating cells in this workbook.

Click the Formulas tab on the Excel Ribbon, and click Calculate Now or Calculate Sheet.