Difference in 2 Dates

[Joan McRae]

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

[#2]

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.