Do you want it to be a static date that doesn't change tomorrow?

If so, you will need event code.

If not, just enter in B5 =IF(A51,TODAY())

If A5 is still greater than 1 tomorrow, the result will update.


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 18:47:01 -0700, Shaggy
wrote:

Can anyone help,
I need a formula to automatically put the current date into a cell if the
cell next to it is greater than 1
EG. If 'A5' = 1000 then 'B5' = Todays Date