Keeping Records

[abxy]

ok, I have two columns...

names go in column A, and dates go in column B.

I need a way to make it so that when a Name is entered in a cell i
column A the today's date will automatically appear in column B.

At first I tried using the TODAY function in my formulas, but tha
function always updates to reflect the current date. I'm keepin
records, so if the date was always changing it wouldn't be useful.

Basically, I need it so that when i enter something in column A, colum
B will display today's date, _not_ the current date.

Thanks for the help in advanc

 

[Frank Kabel]

Hi
have a look at the following site for datestamps
http://www.mcgimpsey.com/excel/timestamp.html

Frank

 

[abxy]

That link gave me the needed information to solve not one, but two, o
my problems! Thanks a lot for the help Frank Kabel, your help is alway
appreciated greatly!

To everyone that wants to know the solution to how to , here you go:

You can use a circular reference to enter the time when a change i
made in another cell, then maintain that time. Choos
Tools/Options/Calculation (Preferences/Calculation for Macs) and chec
the Iteration checkbox. Then, if your target cell is A1 and you wan
the date/time to appear in B1, enter this in B1:

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

(quoted from the page that Frank Kabel posted the link to)

And a little VBA that i did to too, to make a macro that returns th
date and maintains that date:

ActiveCell.Value = Format(Now, "m/d/yyyy")

I hope this helps someone else who also had the same problem as me
Thanks again Frank Kabel

 

[Tom Ogilvy]

Using circular references turns off circular reference checking for all your
workbooks inviting errors. It also will raise errors for someone else
opening your workbook because very few people have iteration checked. But
maybe it won't affect you.