• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

How do I automatically insert/record date in Excel?

R

r_holmes22

Limp Gawd
Joined
Jan 29, 2002
Messages
226
Hi there. I hope somebody can advise. I am using an Excel spreadsheet to record client information at work. It would be most helpful to me if I could format all the cells in a particular column to automatically insert the date when I insert data in the row, but doesn't then insert a new date if I were to open and browse the file on a different day (if you see what I mean). I've tried using =today() which helpfully inserts today's date whenever I open the template. Unfortunately when I open the file days later to check the details in the record, the date field updates to the current date (i.e. the date on which it is being viewed, not the date the file was created).

To try to clarify...I have a single worksheet on which I record client data throughout the year. I, say, put Name in Column A, Location in column B, Gender in column C, and the date they were inroduced to the service in column D. It would be nice if, whenever I enter the usual data in columns A, B and C it would automatically insert the current date in column D and that information would still be there if I open the spreadsheet weeks later. Re-reading this I am feeling this is probably too complex for there to be an easy answer, but just thought I'd ask in case anybody has done this before.

Thanks for your time.
 
I'm on my lunch break right now, but I'll look when I get home. It's a formula someplace, and isn't very hard to do. I just don't remember exactly how at the moment. Hang on, unless someone comes along with an answer in the meantime.
 
mosin said:
I'm on my lunch break right now, but I'll look when I get home. It's a formula someplace, and isn't very hard to do. I just don't remember exactly how at the moment. Hang on, unless someone comes along with an answer in the meantime.
Click to expand...

Much appreciated; thank you.
 
Well...
When I used to have car payments, I had a sheet with this all figured out. Now, like you, I'm having problems. In the old Excel this was easier, but now I have Office 2000, and the formulas work a bit differently. I haven't given up, however.
 
I'm encouraged that it was possible on older versions of Excel. Hopefully the feature has been translated to more recent versions under a different guise.

Many thanks for your tenacity. Don't go overboard though; it's not that important (I'm just lazy!)

Cheers.
 
You must log in or register to reply here.
Back
Top