Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel

Microsoft Excel

ResolvedVersion 2007

Fri 13 Nov 2009, 10:02 Delegate Stuart said...

Stuart has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Microsoft Excel

Good morning

Could you please help me! I am designing a Spreadsheet for our archiving records

I have entered a date of which the box went into archive i.e

07.05.2004

i have added another colunm called Review date and wish the review date to be 3 years from the date the box went in so i want it to be 07.05.2007.

Is there a formula that can help me rather than freetyping the review date?

Thks!

Fri 13 Nov 2009, 13:57 Trainer Simon said...

RE: Microsoft Excel

Hi Stuart,

Thank you for your question.

Can you please make sure your dates have been entered using forward slashes or dashes and then formatted as dots.

Try the following formula in cell A2 where A1 contains the Archive date:

=DATE(YEAR(a1)+3,MONTH(a1),DAY(a1))

This formula adds 3 years to the date in cell A1 and returns the same Month and Day. You can also add numbers to the month and day if you need to.

I hope this answers your question.

Regards

Simon