Never mind!!! I'm ridiculous! I figured it out!!!!

"Zoe" wrote:

So, here is the formula I'm using. Some cells it's adding 2 or 3 days to the
MONTH and some cells it's not. I don't WANT it to add 2 days. It should just
be adding 5 years and leaving the month and day the same... what is happening
here?

=IF(J5="","",DATE(YEAR(J5)+5,MONTH(J5),DAY(J6)))