M
MathewPBennett
Good evening all,
I have some simple code, that when 't' is entered into a cell,
todays date (NOW) is automatically entered.
However I would like to have the date of the following Friday
entered instead of today (NOW).
I am unsure if this is possible, but any help on this matter
would as usual be most appreciated.
Here's my code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then
If Target = "t" Then
Target.Value = Format(Now, "mm-dd-yy")
End If
End If
End Sub
Thank you
Mathew
I have some simple code, that when 't' is entered into a cell,
todays date (NOW) is automatically entered.
However I would like to have the date of the following Friday
entered instead of today (NOW).
I am unsure if this is possible, but any help on this matter
would as usual be most appreciated.
Here's my code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then
If Target = "t" Then
Target.Value = Format(Now, "mm-dd-yy")
End If
End If
End Sub
Thank you
Mathew