Help with formating

[Guest]

I have a schedule to take meds three times a day every day every month. How
can I change the name of the month by using the find and replace function or
other methods...Thank YOu in advance. Greg

Date Time
1-Mar 6:30 am
1-Mar 11:30 pm
1-Mar 4:30 pm
2-Mar 6:30 am
2-Mar 11:30 pm
2-Mar 4:30 pm
3-Mar
3-Mar
3-Mar
4-Mar
4-Mar
4-Mar

 

[Guest]

hi again,
i made a mistake in the formula. it should be.....
=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))

sorry
FSt1

 

[Guest]

hi,
if your date data in formated as text, the find and replace all will work.
if your date data is fromated as date then try something like this in a
blank column (in your example - column C)......
=DATE(YEAR(A2),MONTH(A)+1,DAY(A2))
copy the formula down the C column, then copy the formula column and paste
special values in the date column....or where ever you want it.

regards
FSt1