someone else will probably be able to explain why this produces Oct 29, not Oct 28...

Excel treats 1900 as a leap year.

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm