Need formula for excel date?

let say i enter todays date in a cell (A1). What formula can i use to make A2 show three years from now once A1 is entered. Remember i enter just one date and get 2 dates (todays date and 3 years later date)

Need formula for excel date?
See the EDATE function.





In this case, you want EDATE(TODAY(),36)
Reply:=DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))
Reply:Excel stores time/dates as a number of days from 1 jan 2001. To calculate a date in the future, just add the number of days until the date you want to calculate. I.E. cell a1 contains =TODAY(). To calculate 3 years from now, cell A2 would contain =A1 + (365 * 3)


Note that this is a simple version and won't account for leap years...