How to change dates

S

Sparkman

Is there a formula that will allow me to change the
current date in one cell to one 2 years from now.
 
S

sunroyal

Try putting the date in one cell and having the another cell return a
sum of that cell plus 730, ex. =sum(a1+730). Format as date dd/mm/yy.
 
G

Guest

-----Original Message-----
Is there a formula that will allow me to change the
current date in one cell to one 2 years from now.
.
Click to expand...
This should give exactly what you want...

assume your date is in cell A1
enter the following formula in B1

=DATE(YEAR(A1)+2,MONTH(A1),DATE(A1))
 
Top