need held for auto date calculation for adding years and substract

  • Thread starter Thread starter srinivas
  • Start date Start date
S

srinivas

A1 22-03-88 Start Date (ddmmyy)
A2 19-06-08 Endt Date
A3 Difference betwwen two dates
A4 20 years, 2 months, 27 days (=DATEDIF(A12,B12,"y")&" years,
"&DATEDIF(A12,B12,"ym")&" months, "&DATEDIF(A12,B12,"md")&" days")
A5
A6 Now some years to add for substraction from a4 cell
A7
A8 1 years, 1 month 25 days
A9 2 years, 0 months 4 days
A10 1 year, 6 months 1 days
A11
A12 Here I need a formula to add A8 to A10 ?
A13
A14 manually it is 4 years, 8 months,0 day ( i.e. A4 - ( A8+A9+A10)
A15
A16 Here I need a formula to substract from difference between two dates-No
of years for substration ( i.e. A4 - A12)
A17
A18
A19 Now I have add 3 years for A14 result? how can enter 3 years
A20
A21 Now here Total years : how ? (i.e. A16 + A19)
KINDLY HELP TO SOLVE THE ABOVE PROBLEM
 
It's a case of not sufficient design, instead of concatenating formulas and
add
text in the like years, months etc in one cell you should put them in
separate cell with headers
like Years, Months and Days. That way your data would be numbers.

--


Regards,


Peo Sjoblom
 
Back
Top