The formulas work on my machine (except, with the -1 in there, I get the last day of the month).

Perhaps your date system is not set correctly on your system or in the Excel options.

That probably won't help, but it may be a start.
Mark