In Cell A1 these are date of join 25-Aug-15
26-Aug-15
01-Sep-12
16-Sep-12
11-Oct-12
16-Oct-13
18-Oct-15
22-Oct-11
29-Oct-11
29-Oct-11
01-Dec-13
03-Dec-11
10-Dec-13
I used this formula DATE(YEAR(TODAY()),MONTH(a1),DAY(a1)) Its work but not 100 % when I put this formula its give for all 2015. Dec should be 2014 because we are still in Nov month. Can some one help me for this formula please