Date Errors

**excel_8543** · 01-10-2007, 10:48 AM

Yes and no, I noticed in the original sheet that the date function stopped working as of 01-01-2007. So I created an exact duplicate and entered the same formula into the sheet.

Something is really weird here, I just went back to the original sheet and made a new entry, when I do this, I get a date value of 10-Jan-
07.

Yesterday this was not possible. The formula and option settings in this original exactly match the one I zipped in this forum. So how can one work and not the other? I attached a working copy of this sheet. password is set to: temp

**oldchippy** · 01-10-2007, 10:56 AM

Thought this what is was, you have a macro that does the FixedDate function. You can see it by right-clicking on the xl icon to the left of File, it's under Module 1, you need to copy this to your new workbook