View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
krishna K krishna K is offline
external usenet poster
 
Posts: 1
Default Find & replace different years (part of the date)in a column

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.