Find and Replace only the first character
Thank you so much! This was VERY helpful!!!!!
"tompl" wrote:
Assuming that your date format is Month, Day, Year you could use the
following formula to compute the change from June to July. Other months
would not be affected.
First, assuming your original date is in cell A2, put this formula in Cell B2:
=IF(MONTH(A2)=6,DATE(YEAR(A2),7,DAY(A2)),A2)
Next, Paste-Special-Values from Cell B2 to Cell A2. Then you can clear the
contents of Cell B2.
Tom
|