| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need held for auto date calculation for adding years and substract
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need held for auto date calculation for adding years and substract
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 "srinivas" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding 40 years to date | Excel Discussion (Misc queries) | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Adding years to a date | Excel Discussion (Misc queries) | |||
| How do I substract numbers in range like this: Substract(a1..a10) | New Users to Excel | |||
| Excel Adding years or months to a date | Excel Discussion (Misc queries) | |||
Hybrid Mode
