Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find & replace different years (part of the date)in a column
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))
OR handling blanks. =IF(A1,DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)),"") -- Jacob (MVP - Excel) "krishna K" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
How do I find age in years from anniversary date (Age funtion)? | Excel Worksheet Functions | |||
Find and replace part of a text string | Excel Discussion (Misc queries) | |||
Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) |