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

identify which years are contained within a range of dates 2
Allocate an income payment over a date range (tax years) 7
Create dates for year, allow for leap year 8
merging duplicate donors and donation amounts from different years 8
Sorting dates, ignoring year 3
Counting dates with specific criteria 1
Count partial dates 1
Date Time decimal value help please 1

Top