Forum Discussion

Lucas T. Faria's avatar
Lucas T. Faria
Copper Contributor
Jul 23, 2018

Calculate Difference on Time

Good day, everyone,

 

I have made the following Excel table:

 

 

 

I would like that the table would do the following:

After the entry in "Entry", I would like that the column "Last" finds the latest entry before the current, and in column C, calculate de difference between the dates. 

 

Example: I have 4 entries now. 

A3 has July 21; that way B3 would calculate the contents of the latest entry before July 21, which would be July 18, and calculate the difference between the dates – i.e. 3 in C3.

 

Thank you. 

 

 

  • Hi Lucas,

     

    If you mean most closest to the current record date when starting from B3

    =MAX($A$1:$A2)

    in B3; and in C3

    =A3-B3

    drag both cells down

     

     

Resources