I've been trying to use a formula that will auto-populate the next anniversary date for an employee.

The formula I am using will get the correct year, but not the month and day right. Here's what I am using:

=edate(E3,(datedif(E3,TODAY(),"y")+1)*12)

Here's a link to the spreadsheet if you'd care to take a look.

https://docs.google.com/spreadsheets...it?usp=sharing

Any suggestions are appreciated!