Forum Discussion

Joan McRae's avatar
Joan McRae
Copper Contributor
Jul 12, 2017

Difference in 2 Dates

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

 

excel

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jul 12, 2017

    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.