Your problem: You have a formula that inserts the current date: =IF(B3="","",TODAY()) But of course, every day, the date changes. You want the date to update ONCE, then stay fixed.
What sort of solution are you looking for? something "automatic"? or "manual"? You could: manually copy/paste special -> Values to convert the formula to a date. Or, if you're comfortable with VBA, you could create a "change event" that checks to see if the change is made to column "B" or "E", then, insert the date. like: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If ((Target.Column = 2) _ Or (Target.Column = 5)) Then Cells(Target.Row, Target.Column + 1).Value = Date End If End Sub Paul ----- Original Message ---- > From: hemant shah <hemanthin...@gmail.com> > To: excel-macros@googlegroups.com > Sent: Tue, September 14, 2010 4:06:46 PM > Subject: $$Excel-Macros$$ Fwd: Date Stamp Help > > Hi, > > > > Can you please help. > > > > Regards, > > Hemant Shah > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the >learning and support from the group.Let friends and co-workers know they can >subscribe to group at http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
