Keep month and date - change year

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

The above formula worked perfectly but I failed to realize that newly added dates with the current year need to generate the due date for the following year. For example if the date is September 4, 2013 the due date needs to generate as September 4, 2014. Is there a way to alter the previous formula to get this result as well?

I cannot see your attachment can you please send to my mail id [email protected] please

Hi I do not that, I cannot attached excel sheet for your reference please see below
A1) 18-Aug-12 18-Aug-15 DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))
B1) 22-Aug-15 22-Aug-15 DATE(YEAR(TODAY()),MONTH(b1),DAY(b1))
C1) 23-Aug-15 23-Aug-15 DATE(YEAR(TODAY()),MONTH(c1),DAY(c1))
D1) 29-Oct-11 29-Oct-15 DATE(YEAR(TODAY()),MONTH(D1),DAY(D1))
E1) 01-Dec-13 01-Dec-15 01-Dec-14 DATE(YEAR(TODAY()),MONTH(E1),DAY(E1))-365
F1) 03-Dec-11 03-Dec-15 03-Dec-14 DATE(YEAR(TODAY()),MONTH(F1),DAY(F1))-365

Thank you so much for your help !!!

Good morning Siva; I have one more problem with excel formula. In my company have two nationality’s employees One is “TCN” second is “ EXPERT” – In condition if TCN has vacation for 23 week means 161 days and Expert has vacation for 14 weeks means 98 days
Base on employee start date how to generate next vacation date, formula that need to choose among them (TCN or EXPERT days (161 or 98)
Example:
EXPERT: DOJ is 13-OCT-15 + 98 Days for his vacation will be on 19-JAN-16
13-Oct-15 19-Jan-16

TCN: DOJ is 01-JAN-15 + 161 Days for his vacation will be on 11-JUN-15
01-Jan-15 11-Jun-15

Would you please help me for conditional formula please !!!

TMP Employees Master File.xlsx

Please see attach in "VC matrix" tab I am using like divided two sections one TCN and one Exipet. Actually I wan to make only one section please help me for formula

Good morning; I have problem with excel formula. My company have two nationality’s employees One is “TCN” second is “ EXPERT” – In condition if TCN has vacation for 23 week means 161 days and Expert has vacation for 14 weeks means 98 days
Base on employee start date, how to generate next vacation date, formula that need to choose among them (TCN or EXPERT days (161 or 98)
Example:
EXPERT: DOJ is 13-OCT-15 + 98 Days for his vacation will be on 19-JAN-16
13-Oct-15 19-Jan-16

TCN: DOJ is 01-JAN-15 + 161 Days for his vacation will be on 11-JUN-15
01-Jan-15 11-Jun-15
Please see attach in "VC matrix" tab I am using like divided two sections one TCN and one Expect. Actually I want to make only one section please help me for formula

Can you please help me for above formula

I have problem with excel formula. My company have two nationality’s employees One is “TCN” second is “ EXPERT” – In condition if TCN has vacation for 23 week means 161 days and Expert has vacation for 14 weeks means 98 days
Base on employee start date, how to generate next vacation date, formula that need to choose among them (TCN or EXPERT days (161 or 98)
Example:
EXPERT: DOJ is 13-OCT-15 + 98 Days for his vacation will be on 19-JAN-16
13-Oct-15 19-Jan-16

TCN: DOJ is 01-JAN-15 + 161 Days for his vacation will be on 11-JUN-15
01-Jan-15 11-Jun-15
Please see attach in "VC matrix" tab I am using like divided two sections one TCN and one Expect. Actually I want to make only one section please help me for formula
Lokesh - Sample.xlsx

Thank you so much sir. Let me try this