Dates and Future Dates

[mantona]

If I have a date in box A1 'DD/MM/YYYY' then is it possible to predict a date 6 months, 12 months and 18 months from then? These new dates would appear in B1, C1 and D1.

Thank you for your help in advance.

 

[JD_GFI]

Hi mantona,

Take a look at the eDate function in the analysis add-in. It should do what you need.

 

[mantona]

Works perfectly!

Thanks again. I really do appreciate your help.

 

[njimack]

Enter the following into B1 and copy across:
=DATE(YEAR($A1),MONTH($A1)+6*(COLUMN()-1),DAY($A1))

 

[mantona]

Thanks also for your reply. I will give that a go as well.