Date/time stamp of when data was entered

[ANE0709]

is there a way to date/time stamp when an entry is made? I tried to use =today() and =now() but when we close/reopen the file it changes to the current date/time which isnt what i need.

 

[Joe4]

Yes, there are literally hundreds of threads on this forum about how to do it.
Do a search here (or a Google search) and you will see them.

If you need more specific help, please provide more specific details (i.e. where entries are occurring, where timetamps should show up).

 

[ANE0709]

hmm ok, maybe im just not using the correct search keywords. i have found a few examples on the web via formula and VBA but the date/time keep refreshing and i dont want that. I'd really prefer to stick with formula is possible.

example of my data is: if B2 is changed then insert date/time stamp in C2 and need to be able to apply to entire column.

 

[Joe4]

See option here to see how to do it without VBA.
It involves creating a circular reference and using iteration.

How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]

In general, it contains the current date and time and we have different methods but, the thing is, which is the best way to insert a timestamp in Excel?

excelchamps.com

Personally, I prefer a VBA approach, something like I show here: Timestamp that want change when workbook is opened

 

[ANE0709]

See option here to see how to do it without VBA.
It involves creating a circular reference and using iteration.

How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]

In general, it contains the current date and time and we have different methods but, the thing is, which is the best way to insert a timestamp in Excel?

excelchamps.com

thanks. ill look read up on it and circle back if i still cannot figure it out.

 

[Joe4]

You are welcome.

Note that I edited my previous post to also include a link to the VBA approach I typically use.

 

[ANE0709]

You are welcome.

Note that I edited my previous post to also include a link to the VBA approach I typically use.

Ah, ok. that link you sent gave me the terminology i needed to more efficiently research the topic and was able to nest together a formula based solution which so far is serving the needs. Thanks for getting me in the right direction!