Static Date in Formula

  • Thread starter Thread starter Eaon Whatmough
  • Start date Start date
E

Eaon Whatmough

Dear Group,

HELP!

Excel/Access Problem

I want Excel/Access to insert a date (which remains
static) in a column/field automatically dependant on the
action in another column/field without recalculating so
that when viewed at a later date one can see when the
original action took place.

e.g. If(A1>0,TODAY(),0) or IIF([NUMBER]>0,DATE(),0)

the problem here being that they both recalculate.

Ideally the formula should read IF(A1>0,CTRL+;,0) or IIF
([NUMBER]>0,CTRL+;,0).

What do I need to replace CTRL+; (semi-colon) with?

Help stop sleepless nights, unused bed and red hot
computer due to being on constantly.

Thanks
 
Back
Top