Forum Discussion
fixed date
Hello, I have this problem: I need when I write something in cell B1 then G1 gives me the date(date of writing). I've tried this formula in G1: =IF(B1<>"";NOW();"") but it doesn't work ...
Hi Ahmad,
Formulas are not capable to do that!
You have to use a VBA code instead.
I would suggest this code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("B1")) Is Nothing Then
Range("G1") = Now
End If
On Error GoTo 0
End Sub
Please check out my replies to this post which is similar to what you asking for.
Hope that helps
Haytham Amairah Thank you so much .... and I'm very sorry for the delayed response
thank you again
best,
Ahmad