I have five columns for one excel file using 2003 version
column A column B column C column D column E
27.8.2009 5 01.10.2011 X Y

column B means five years, X is derived by A+B-C in terms of years, column E is in terms of month. so for above example, X will be 2 (years) , Y will be 10 (months)

my major problem is how to design formula for column D and E? I have around 1000 such records

all columns are defined as general category, even if I try to format cells to "date" for column A
it can't be changed, so how to solve the issue? thanks