S Sparkman Oct 22, 2003 #1 Is there a formula that will allow me to change the current date in one cell to one 2 years from now.
Is there a formula that will allow me to change the current date in one cell to one 2 years from now.
S sunroyal Oct 22, 2003 #2 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.
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 Oct 22, 2003 #3 -----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))
-----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))
