Timestamp without VBA

[Wisyr]

Hello experts,

I'm currently having trouble with a formula in Excel. I'm wondering if there's any way to get a timestamp without having to refresh all of the rows. So far, I've managed to put a formula in place that seems to be working perfectly, with one small issue: when I change the value in the cell, the timestamp doesn't refresh to a new one. Any advice on how to fix this would be greatly appreciated.

=IF(A1<>"", IF(B1="", NOW(), B1), "")

 

[awoohaw]

Your question is very similar to this thread, you may find an answer here.
But, I'd like to add:

1. NOW() is a volatile function, it will recalculate EVERY time your sheet calculates ANYTHING and everytime your workbook opens. So, it will not be a STAMP.
2. In the thread linked below, there are a few different ways to approach your question. But, if you want to enforce recalculation then I'd suggest looking at the posts involving DATA VALIDATION, if you want a single formula solution, there are other posts for that.

Best wishes!

Date and Time Stamp

Is it possible to add a formula or instruction to a standard text in excel so when I copy and paste it will automatically add the date and time stamp? This is a sample of a standard text I use since I approve 100's of personnel actions a day: "Approved by Mr. John Doe on 05 May 23, 12:12 PM"...

www.mrexcel.com