Hi Viv,
Sure thing! You can use the
DATE function in Excel to calculate a date 6 months forward from another date. Here's how:
- First, enter the start date in a cell. Let's say it's in cell A1.
- In another cell, enter the following formula: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
- Press Enter, and the cell should display the future date 6 months forward from the start date.
So, in your example, if the start date is
27/01/2010 in cell A1, you would enter the formula
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) in another cell and it should return the future date of
27/07/2010.
I hope that helps!