Calculate number of days since last type of entry

[Ironman]

Hi

The below range A8621:C8629 (but which starts from A12) shows 3 different types of entry in Column B: REST, OTHER and a route description (for running).

A2 (not shown) contains today's date

=TEXT(TODAY(),"d mmmm yyyy")

What I'd be very grateful for is a formula that will show the number of days since I last went running i.e. the latest date where Column B does not contain REST or OTHER.

For example, I last went running 4 days ago so I would expect the result to be 4 until I input today's running entry, when the result would change to 0.

Many thanks!

Wed, 28 Jul 2021	Cullingworth Rd/Viaduct/ Stn Road/Old Allen Road Back Lane/Wilsden Rd/ Cottingley Rd/Lee Lane/ Cross Lane/Coplowe Ln/ Crack Lane/Main Street/ Harden Ln/Mill Hill Top/ Wilsden Rd/Mad Mile/ Greenside Lane (21/02/2020)	10.6
Thu, 29 Jul 2021	OTHER
Fri, 30 Jul 2021	REST
Sat, 31 Jul 2021	OTHER
Sun, 1 Aug 2021	Cullingworth Rd/Viaduct/ Stn Road/Old Allen Road Back Lane/Wilsden Rd/ Cottingley Rd/Lee Lane/ Cross Lane/Coplowe Ln/ Crack Lane/Main Street/ Harden Ln/Mill Hill Top/ Wilsden Rd/Mad Mile/ Greenside Lane (21/02/2020)	10.6
Mon, 2 Aug 2021	OTHER
Tue, 3 Aug 2021	REST
Wed, 4 Aug 2021	OTHER
Thu, 5 Aug 2021	Hallas Br/Down Bents Ln Harden Lane/Smithy Ln/ Lee Farm/Black Hills/ Golf Course/R down Beck Foot Lane/Wagon Lane/ Up LLC to cannon monument/Back to 3-Rise Locks & over Br/ Brown Cow/Main Road all the way back home (22/04/2007)	15.4

 

[richh]

=IF(AND(C2<>"OTHER", C2<>"REST"), DAYS360(B2,A2, FALSE), "")

 

[Eric W]

Try:

Book1
	A	B	C
1			Days since I ran last
2	5 August 2021		0
3
4
5
6
7
8
9
10
11
12	7/28/2021	asdf
13	7/29/2021	other
14	7/30/2021	rest
15	7/31/2021	other
16	8/1/2021	asdfasdf
17	8/2/2021	other
18	8/3/2021	rest
19	8/4/2021	other
20	8/5/2021	asdfasdf
21	8/6/2021
22	8/7/2021
23	8/8/2021
24
Sheet17

Cell Formulas
Range	Formula
A2	A2	=TEXT(TODAY(),"d mmmm yyyy")
C2	C2	=TODAY()-MAXIFS(A12:A9000,B12:B9000,"<>REST",B12:B9000,"<>OTHER",B12:B9000,"<>")

 

[Ironman]

Richh - Many thanks for your response. Unfortunately for some reason, I get the #VALUE error with your formula.

Eric - your solution works perfectly, many thanks.

 

[Eric W]

Glad we could help!