|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
05-18-2009, 09:21 AM
|
#1 (permalink) |
|
Registered User
Join Date: May 2009
Posts: 2
OS: Windows XP Pro
|
Date Stamp
Right now i am using =IF(ISBLANK(D7),"", NOW()) formula to post the date once a cell is updated. I understand the NOW part is the reson why every day when i open up the sheet the day updates to the current day. I am trying to get this so when one of my agents adds there name in a cell the cell next to it will update with the current date and keeps that day. Is there a formula that i can use to add a Date Stamp and keep the date stamp?
All help would be great. Thanks |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
05-18-2009, 01:34 PM
|
#2 (permalink) |
|
Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic
|
Re: Date Stamp
Hi and welcome.
The best way is to use a macro - plenty of examples on the web - try this one http://www.mcgimpsey.com/excel/timestamp.html
__________________
Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums.   PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner |
|
|
|
|
05-19-2009, 05:15 AM
|
#3 (permalink) | |
|
Registered User
Join Date: May 2009
Posts: 2
OS: Windows XP Pro
|
Re: Date Stamp
Quote:
|
|
|
|
|
|
| Thread Tools | |
|
|
