Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
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
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!
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
Excel Formula:
=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 |
Last edited: