conditional update to date field

Is there an easy way to upate a date field with the current date only when the files contents have been changed?

Thanks in advance for your help!

Sydni

Hi,

Do you mean something like :
=IF(A1=1,TODAY(),"no update")

HTH
Carim

No. I'm looking to change the date field automatically when any cells within the file have been updated.

Thanks,
Sydni

Hi,

Please Login or Register  to view this content.

HTH
Carim

That works beautifully. Thank you so mucch for your help!
I guess I need to go buy a "for Dummies" book on Visual Basic. I'm certain that would make my life much easier.

Sydni

Glad your problem's fixed

Thanks for the feedback

Carim