I also tried this equation:
=IF(ISBLANK(D1),"",IF(B1="",FixedDate(),B1))
D = driving value. Once data is entered here, a fixed date is placed in B
B values are still returning at 0-Jan-00.
I used this FixedDate command from September 06 to Dec 06 without any issues. Once we got into Jan 07, it no longer works.
Bookmarks