Mon 2 Mar 2009, 08:34Delegate Su said...
Su has attended:
Excel Introduction course
Date forumulas
I have a spreadsheet with a date in the first column the 2nd column date needs to be one year on from this and the 3rd column date 2 years on. Anyone know how to set this up?
Tue 3 Mar 2009, 10:23Trainer Cress said...
RE: Date forumulas
Hello Su
Thank you for your question
Assuming the original date is in cell A1, try this formula in another cell and remember to format the column as date:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
