Find & replace different years (part of the date)in a column

K

krishna K

I have the various dates on which our staff have joined the organisation. I
need a column that would convert all the year part of the date into the
current year so that the increment date could be traced. Single command or
macro would do. I need this feature in Excel sheet, preferably. However, if
there is any other option, i would like to pursue it as well. Writing of code
should be avoided.
 
J

Jacob Skaria

=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

OR handling blanks.
=IF(A1,DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formula - in Years 3
Find & Replace: find part cell, replace whole cell 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
IF and DATE Formula Help PLEASE 6
Adding only part of a column of data 3
counting the occurrence of specific text within a date range 4
all dates in a column have gone back four years 2
change a list of 2 digit years to 4 digit years? 5

Top