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.