| 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 |
| 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) | |||
Threaded Mode
