need held for auto date calculation for adding years and substract


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
 
Ad

Advertisements

P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top