Forum Discussion
Solved
NOW() function
Hello everyone, For the past 6 hours I've been trying to figure out how to get an automatic timestamp in Excel. I would like to know if it is possible to use the NOW() in an IF(). Form example: ...
- timestamps are a common question/request. There are tricks using circular reference to create a persistent timestamp (i.e. it doesn't change) but they will also require changing the sheet setting to allow circular refs but limit the re-iterations.
you can also use a macro to create a timestamp base on a certain event
but the easiest thing to do if you just want a shortcut to enter the date and/or time is to use the shortcuts: ctrl-; for date and ctrl-shift-; (or ctrl-:) for the time
timestamps are a common question/request. There are tricks using circular reference to create a persistent timestamp (i.e. it doesn't change) but they will also require changing the sheet setting to allow circular refs but limit the re-iterations.
you can also use a macro to create a timestamp base on a certain event
but the easiest thing to do if you just want a shortcut to enter the date and/or time is to use the shortcuts: ctrl-; for date and ctrl-shift-; (or ctrl-:) for the time
you can also use a macro to create a timestamp base on a certain event
but the easiest thing to do if you just want a shortcut to enter the date and/or time is to use the shortcuts: ctrl-; for date and ctrl-shift-; (or ctrl-:) for the time
mtarler Thank you so much for your reply even though this is a frequently asked question! I think you gave me just the right info to search up some ways to make this work 🙂
