Hi all
I used the below formula (searching online I found that NOW gives you a time stamp as opposed to TODAY which updates the date regularly)
=IF(A3<>"",NOW(), "")
The reason behind the below is that when someone enters a value the timestamp is generated for audit purposes. I used the below formula yesterday to test and noticed that the date had updated to todays date.
Have I entered something wrong here?
As always any help is very much appreciated. Ps if I am delayed in responding currently at work but shall get back to any replies.
Thanks
I used the below formula (searching online I found that NOW gives you a time stamp as opposed to TODAY which updates the date regularly)
=IF(A3<>"",NOW(), "")
The reason behind the below is that when someone enters a value the timestamp is generated for audit purposes. I used the below formula yesterday to test and noticed that the date had updated to todays date.
Have I entered something wrong here?
As always any help is very much appreciated. Ps if I am delayed in responding currently at work but shall get back to any replies.
Thanks