Difference in 2 Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-86931%22%20slang%3D%22en-US%22%3EDifference%20in%202%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86931%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20assistance%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA1%20%3D%20Date%201%26nbsp%3B%26nbsp%3B%20(May%2029%2C%202017)%3C%2FP%3E%3CP%3EA2%20%3D%20Date%202%26nbsp%3B%20(Feb%2022%2C%202010)%3C%2FP%3E%3CP%3EA3%20%3D%20Date%203%20(June%2013%2C%202017)%3C%2FP%3E%3CP%3EA4%20%3D%20Difference%20in%20total%20length%20of%20time%20between%20A3%20-%20A1%20(15%20days)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%2C%20I%20want%20to%20calculate%20A5.%3C%2FP%3E%3CP%3EA5%20%3D%20A4%26nbsp%3B%2B%20A2%20(to%20calculate%20a%20new%20date)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20don't%20know%20how%20to%20use%20A4%20-%20the%20amount%20of%20time%20(years%2C%20months%20and%20days)%20and%20add%20it%20to%20a%20Date%20that%20is%20in%20cell%20A2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-86931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-86950%22%20slang%3D%22en-US%22%3ERe%3A%20Difference%20in%202%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Joan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20problem%3F%3C%2FP%3E%3CP%3EYou%20wrote%20it%20yourself%2C%20the%20result%20in%20A4%20is%2015%20%3CU%3Edays%3C%2FU%3E.%3C%2FP%3E%3CP%3EAnd%20if%20you%20add%2015%20days%20to%20Feb%2022%2C%202010%20then%20you%20get%20Mar%2003%2C%202010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA4%20is%20always%20measured%20in%20%3CU%3Edays%3C%2FU%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Any assistance would be appreciated.

 

A1 = Date 1   (May 29, 2017)

A2 = Date 2  (Feb 22, 2010)

A3 = Date 3 (June 13, 2017)

A4 = Difference in total length of time between A3 - A1 (15 days)

 

Then, I want to calculate A5.

A5 = A4 + A2 (to calculate a new date)

 

I just don't know how to use A4 - the amount of time (years, months and days) and add it to a Date that is in cell A2

 

1 Reply
Highlighted

Hello Joan

 

What is the problem?

You wrote it yourself, the result in A4 is 15 days.

And if you add 15 days to Feb 22, 2010 then you get Mar 03, 2010.

 

A4 is always measured in days.