Help with date formula

  • Thread starter Thread starter boltman17
  • Start date Start date
B

boltman17

Hello All:

I am trying to find a formula that will do the following:

When text or numbers is entered or updated into a cell (a2) the
current date is automatically posted into the ajoining cell to the
left (a1) It woud be ok if the current date was entered when the
formula is originally pasted to the cell, but would be better if the
date cell remained blank until the text or formula cell was modified.

My hats off to you folks that write these formulas. This stuff is way
beyond me!!!

Thanks for your help.

Keith Thompson
 
In B1 add this formula

=IF(A1<>"",TODAY(),"")

and format B1 as date.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You would need a worksheet_change event, something like:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Count > 1 Then Exit Sub
If Intersect(Target, Range("A2")) Is Nothing Then Exit Sub
With Target
.Offset(-1, 0).Value = Now
.Offset(-1, 0).NumberFormat = "m/d/yy"
End With
End Sub


Right-click on the worksheet tab, View Code, and paste
this in.

HTH
Jason
Atlanta, GA
 
Back
Top