Question: what is the formula for year to date in excel?
Answer: To add a given number of years to a date, you can use a formula based on the DATE function, with help from the YEAR, MONTH, and DAY functions. In the example shown, the formula in D5 is: =DATE(YEAR(B5)+C5,MONTH(B5),... Note: Excel has several built-in data validation rules for dates.