How to change dates

  • Thread starter Thread starter Sparkman
  • Start date Start date
S

Sparkman

Is there a formula that will allow me to change the
current date in one cell to one 2 years from now.
 
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.
 
-----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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Using CF to change colour in cell based on date? 4
If/Then Formula Using Dates 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How do a set the current date to change in cell everyday 1
Use first day of month formula in a drop down list 3
Formatting Text to Numbers for Dates 1
time auto entry 11

Back
Top