Century break - when your Excel date just doesn't work out. By Simon Hurst
On the rare occasions when the staff at the ICAEW's IT Faculty are unable to answer a technical question they sometimes refer it to me to see if I have come across the answer.
Recently they forwarded an email from an IT Faculty member, Brian Maggs, who was using Excel to help with his study of genealogy. The problem he encountered related to how Excel copes with dates prior to 1 January 1900. Brian wanted to format the dates with a typical date format of day/month/year but found that Excel would not recognise a date prior to the start of the 20th century as a date.