Hi everyone. I have designed a spreadsheet in 2003 which uses staticdate in a formula e.g. =IF(C34="y",StaticDate()). It works perfectly fine in Excel 2003 but when I open it in Excel 2010 it returns the current date i.e. the date the spreadsheet is being opened on. When I re-open in in 2003 it works perfectly fine, returning the original static dates. I need the original static dates to show when I use 2010 as well. Help!!!!! Thanks in advance