I don't get 21-Jum-09 for adding 12 months and one day but try:

A4: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)+A3)

A5: =A4+12

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"zen" wrote in message
...
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.