Calculating for a specific date range
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
|