Christy,

I've only included the example for the first cell but it's easy enough to
work out for the second.

=DATE(YEAR(A1)+4,MONTH(A1)-6, DAY(A1))

i.e. for May 2007 add 4 year and take away 6 months.

Mike

"Christy P" wrote:

I have a column that lists a date of manufacture for an item. I need the next
colum to tell me the date 6 months before the date of manufacture in 4 years.
I then need it to tell me the date for 6 months after the date of
manufacture in 8 years. So for example, this units date of manufacture is
November of 2003. I need the next column to tell me 5/2007, then for the next
5/2008. Any help?
--
Christy P