DATE
Posted by MC on August 13, 2001 5:34 AM
WHAT IM LOOKING TO DO IS :
IF COULUMN G IS LESS THAN COLUMN H, I NEED THE DATE THAT THIS HAPPENS (TRIGGER DATE)DISPLAYED IN COLUMN J
IVE TRIED TO DO THIS WITH THE NOW() COMMAND BUT THIS WILL DISPLAY THE CURRENT DATE (CHANGED EVERYTIME EXCEL OPENS)I NEED THE DATE FIXED TO THE TRIGGER DATE
IS THIS POSSIBLE
MANY THANKS IN ADVANCE M.C.
