Forum Discussion
Solved
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...
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
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
- Worked like a charm, Sergei.
Thanks!
