Use the 4th arguement to state that you only want to change the first
instance.
=SUBSTITUTE(A2,"6","7",1)
This premise does assume that you have dates stored as text. If you have
them stored as numbers (preferred), you can do:
=DATE(YEAR(A2),7,DAY(A2))
--
Best Regards,
Luke M
"Terry Willard" <Terry
wrote in message
...
I am trying to replace only the first number in a date.
example: 6/6/10 with 7/6/10
I am doing a find 6/ and a replace 7/ but it changes the 7/6 to 7/7 and I
only want to look at the first number in the date. Can anyone help me????