When entering 14/08/06 into cell it is formated to 14 August 0006 (uk date format) instead of 14 August 2006. When I do the same in excel it correctly works out as 14 August 2006. I suppose it isn't strictly a bug but could cause confusion if using the DATEDIF function like I did. I couldn't understand why it was showing 730,852 days!!! difference between now and last year. Anybody found any other bugs.
8/14/07 at 7:49am