Question: how to add and subtract years months and days?
Answer: Add one year =DATE(YEAR(Date)+1,MONTH(Date),DAY(Date))
Subtract one year =DATE(YEAR(Date)-1,MONTH(Date),DAY(Date))
Add two months =EDATE((date),2)
Subtract two months =EDATE((date),-2)
Add three days =(Date)+3.