Jun 11 2020 12:11 PM
Can someone help with a formula for date&time in excel cell? Goal= enter date and current time stamp will populate and not change.
Jun 11 2020 06:06 PM - edited Jun 11 2020 06:08 PM
To insert Date and Time in a single cell, press CTRL+; (semi colon). Then, press space bar on your keyboard and execute CTRL+SHIFT+; (semi colon)
=NOW() function will return Date and Time (which is volatile)
Jun 12 2020 09:43 AM
Oct 30 2020 09:12 AM