A Archduke Joined Mar 4, 2012 Messages 1 Reaction score 0 Mar 4, 2012 #1 Hi all does anyone know if I can create a date in a cell that shows the date that the excel spreadsheet was originally opened and save it I tried =IF(M4=" ","+TODAY()",M4) but it just keeps returning a value of 1st jan 1900
Hi all does anyone know if I can create a date in a cell that shows the date that the excel spreadsheet was originally opened and save it I tried =IF(M4=" ","+TODAY()",M4) but it just keeps returning a value of 1st jan 1900
