Update Date field

[mspincus]

How do you update a date to current yr. I have a column with 3/1/2018, with the next 5/15/2018 and I need them updated to to 2019. Meaning 3/1/2019, and 5/15/2019

 

[smozgur]

1- I would select the range with dates, find 2018 and replace with 2019.

OR if formula is needed.

2- If A1 is 03/01/2018, then I would used following formula in the adjacent cell:

=DATE(YEAR(A1)+1, MONTH(A1), DAY(A1))

This will increment the year. Then I would copy and paste below as necessary, and copy and paste values into the source range.

 

[mspincus]

cell actually starts at c2 and I changed formula but nothng happened.Thank you for trying

 

[Exceladd1ct]

Try this

Sub Replace()
Columns("C").Replace "2018", "2019"
End Sub

 

[mspincus]

i dont know what you mean. have never used code. Sorry. I am a horrible mrexcel person. But THANK YOU for being so patient

 

[Exceladd1ct]

If your data starts in C2, Then please enter the following formula in D2 or E2 or other empty column :

=DATE(2019, MONTH(C2), DAY(C2))

 

[mspincus]

i got it to work! THANK YOU

 

[Exceladd1ct]

You are welcome!

 

[jtakw]

Hi,

You can also use EDATE, format result cells as "Date":

Book1
	C	D
2	3/1/2018	3/1/2019
3	5/15/2018	5/15/2019
Sheet560

Cell Formulas
Range	Formula
D2	=EDATE(C2,12)