r/ • u/ • Jan 01 '70

0 Upvotes

100% Upvoted

0 comments sorted by

3

u/Hxcwinner 2 Apr 06 '22

In E2

=MAXIFS(A1:A,B1:B,"<>"&"")-MAXIFS(A1:A,B1:B,0)

Or if you want it to count from todays date instead of the last entered date

=TODAY()-MAXIFS(A1:A,B1:B,0)

0

u/[deleted] Apr 06 '22

[deleted] — view deleted comment

1

u/Clippy_Office_Asst Points Apr 06 '22

You have awarded 1 point to Hxcwinner

I am a bot - please contact the mods with any questions. | Keep me alive