Zen,

Correct me if I am wrong but I think your due date will be 22-Jun-09.

Anyway, try this.

In A4, type =A1+((365/12)*A2)+A3
This should return a number. Go to Format Cells (Control+1) and change the
format to a date.

This should be 6/22/2009.

In A6, type =A4+A5. This will add your end date to your shut down time.

The result should be: 7/4/2009

Hope that helps.



"zen" wrote:

I need to calculate due after adding certain number of months and days to a
given date. A1 is having a date say 21-Jun-08, in A2 I will enter 12 months &
in A3 I will enter 1 day. In A4 I need calculated due date after 12 months &
1 day, which is 21-Jun-09.Then finally a calculated restart date in A6 after
a shutdown of 12 days, these 12 days will be entered in A5. XYZ company will
complete its operating period of 12M & 1D on 21-Jun-09 and will shut down on
22-Jun-09 to restart on 3-Jul-09 after 12 shutdown days.
It took me long to explain but I need this at my job. Any help will be
highly appreciate.