Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
The below extract is from rows A8413:D8629 for this year's training log and a new row is added every day, down to row 20000. The table starts in Row A12. (Columns B and C are irrelevant).
A2 contains today's date.
I need 2 dynamic formulas to sum the number of times I have run for 2 hours or longer in the current year to date and at the same date last year (whichever years they are) from the times in Column D. The result should be 11 for this year.
A solution would be greatly appreciated.
Thank you!
The below extract is from rows A8413:D8629 for this year's training log and a new row is added every day, down to row 20000. The table starts in Row A12. (Columns B and C are irrelevant).
A2 contains today's date.
I need 2 dynamic formulas to sum the number of times I have run for 2 hours or longer in the current year to date and at the same date last year (whichever years they are) from the times in Column D. The result should be 11 for this year.
A solution would be greatly appreciated.
Thank you!
Fri, 1 Jan 2021 | REST | ||
Sat, 2 Jan 2021 | REST | ||
Sun, 3 Jan 2021 | REST | ||
Mon, 4 Jan 2021 | REST | ||
Tue, 5 Jan 2021 | REST | ||
Wed, 6 Jan 2021 | REST | ||
Thu, 7 Jan 2021 | REST | ||
Fri, 8 Jan 2021 | REST | ||
Sat, 9 Jan 2021 | REST | ||
Sun, 10 Jan 2021 | REST | ||
Mon, 11 Jan 2021 | REST | ||
Tue, 12 Jan 2021 | REST | ||
Wed, 13 Jan 2021 | REST | ||
Thu, 14 Jan 2021 | REST | ||
Fri, 15 Jan 2021 | REST | ||
Sat, 16 Jan 2021 | REST | ||
Sun, 17 Jan 2021 | REST | ||
Mon, 18 Jan 2021 | REST | ||
Tue, 19 Jan 2021 | REST | ||
Wed, 20 Jan 2021 | REST | ||
Thu, 21 Jan 2021 | REST | ||
Fri, 22 Jan 2021 | REST | ||
Sat, 23 Jan 2021 | REST | ||
Sun, 24 Jan 2021 | REST | ||
Mon, 25 Jan 2021 | REST | ||
Tue, 26 Jan 2021 | REST | ||
Wed, 27 Jan 2021 | REST | ||
Thu, 28 Jan 2021 | REST | ||
Fri, 29 Jan 2021 | REST | ||
Sat, 30 Jan 2021 | REST | ||
Sun, 31 Jan 2021 | REST | ||
Mon, 1 Feb 2021 | REST | ||
Tue, 2 Feb 2021 | REST | ||
Wed, 3 Feb 2021 | REST | ||
Thu, 4 Feb 2021 | REST | ||
Fri, 5 Feb 2021 | REST | ||
Sat, 6 Feb 2021 | REST | ||
Sun, 7 Feb 2021 | REST | ||
Mon, 8 Feb 2021 | REST | ||
Tue, 9 Feb 2021 | REST | ||
Wed, 10 Feb 2021 | REST | ||
Thu, 11 Feb 2021 | REST | ||
Fri, 12 Feb 2021 | REST | ||
Sat, 13 Feb 2021 | REST | ||
Sun, 14 Feb 2021 | REST | ||
Mon, 15 Feb 2021 | REST | ||
Tue, 16 Feb 2021 | REST | ||
Wed, 17 Feb 2021 | REST | ||
Thu, 18 Feb 2021 | REST | ||
Fri, 19 Feb 2021 | REST | ||
Sat, 20 Feb 2021 | REST | ||
Sun, 21 Feb 2021 | REST | ||
Mon, 22 Feb 2021 | REST | ||
Tue, 23 Feb 2021 | REST | ||
Wed, 24 Feb 2021 | REST | ||
Thu, 25 Feb 2021 | REST | ||
Fri, 26 Feb 2021 | REST | ||
Sat, 27 Feb 2021 | REST | ||
Sun, 28 Feb 2021 | REST | ||
Mon, 1 Mar 2021 | REST | ||
Tue, 2 Mar 2021 | REST | ||
Wed, 3 Mar 2021 | REST | ||
Thu, 4 Mar 2021 | REST | ||
Fri, 5 Mar 2021 | REST | ||
Sat, 6 Mar 2021 | REST | ||
Sun, 7 Mar 2021 | REST | ||
Mon, 8 Mar 2021 | REST | ||
Tue, 9 Mar 2021 | REST | ||
Wed, 10 Mar 2021 | REST | ||
Thu, 11 Mar 2021 | REST | ||
Fri, 12 Mar 2021 | REST | ||
Sat, 13 Mar 2021 | REST | ||
Sun, 14 Mar 2021 | REST | ||
Mon, 15 Mar 2021 | REST | ||
Tue, 16 Mar 2021 | REST | ||
Wed, 17 Mar 2021 | REST | ||
Thu, 18 Mar 2021 | REST | ||
Fri, 19 Mar 2021 | REST | ||
Sat, 20 Mar 2021 | REST | ||
Sun, 21 Mar 2021 | REST | ||
Mon, 22 Mar 2021 | REST | ||
Tue, 23 Mar 2021 | REST | ||
Wed, 24 Mar 2021 | REST | ||
Thu, 25 Mar 2021 | REST | ||
Fri, 26 Mar 2021 | REST | ||
Sat, 27 Mar 2021 | REST | ||
Sun, 28 Mar 2021 | REST | ||
Mon, 29 Mar 2021 | REST | ||
Tue, 30 Mar 2021 | REST | ||
Wed, 31 Mar 2021 | REST | ||
Thu, 1 Apr 2021 | REST | ||
Fri, 2 Apr 2021 | REST | ||
Sat, 3 Apr 2021 | REST | ||
Sun, 4 Apr 2021 | REST | ||
Mon, 5 Apr 2021 | REST | ||
Tue, 6 Apr 2021 | REST | ||
Wed, 7 Apr 2021 | REST | ||
Thu, 8 Apr 2021 | REST | ||
Fri, 9 Apr 2021 | REST | ||
Sat, 10 Apr 2021 | REST | ||
Sun, 11 Apr 2021 | REST | ||
Mon, 12 Apr 2021 | REST | ||
Tue, 13 Apr 2021 | REST | ||
Wed, 14 Apr 2021 | REST | ||
Thu, 15 Apr 2021 | REST | ||
Fri, 16 Apr 2021 | REST | ||
Sat, 17 Apr 2021 | REST | ||
Sun, 18 Apr 2021 | REST | ||
Mon, 19 Apr 2021 | REST | ||
Tue, 20 Apr 2021 | REST | ||
Wed, 21 Apr 2021 | OTHER | ||
Thu, 22 Apr 2021 | REST | ||
Fri, 23 Apr 2021 | REST | ||
Sat, 24 Apr 2021 | REST | ||
Sun, 25 Apr 2021 | OTHER | ||
Mon, 26 Apr 2021 | REST | ||
Tue, 27 Apr 2021 | OTHER | ||
Wed, 28 Apr 2021 | REST | ||
Thu, 29 Apr 2021 | OTHER | ||
Fri, 30 Apr 2021 | REST | ||
Sat, 1 May 2021 | OTHER | ||
Sun, 2 May 2021 | REST | ||
Mon, 3 May 2021 | OTHER | ||
Tue, 4 May 2021 | REST | ||
Wed, 5 May 2021 | OTHER | ||
Thu, 6 May 2021 | REST | ||
Fri, 7 May 2021 | REST | ||
Sat, 8 May 2021 | REST | ||
Sun, 9 May 2021 | OTHER | ||
Mon, 10 May 2021 | REST | ||
Tue, 11 May 2021 | OTHER | ||
Wed, 12 May 2021 | REST | ||
Thu, 13 May 2021 | OTHER | ||
Fri, 14 May 2021 | REST | ||
Sat, 15 May 2021 | OTHER | ||
Sun, 16 May 2021 | REST | ||
Mon, 17 May 2021 | OTHER | ||
Tue, 18 May 2021 | REST | ||
Wed, 19 May 2021 | REST | ||
Thu, 20 May 2021 | REST | ||
Fri, 21 May 2021 | OTHER | ||
Sat, 22 May 2021 | REST | ||
Sun, 23 May 2021 | OTHER | ||
Mon, 24 May 2021 | REST | ||
Tue, 25 May 2021 | OTHER | ||
Wed, 26 May 2021 | REST | ||
Thu, 27 May 2021 | OTHER | ||
Fri, 28 May 2021 | REST | ||
Sat, 29 May 2021 | OTHER | ||
Sun, 30 May 2021 | REST | ||
Mon, 31 May 2021 | OTHER | ||
Tue, 1 Jun 2021 | REST | ||
Wed, 2 Jun 2021 | OTHER | ||
Thu, 3 Jun 2021 | REST | ||
Fri, 4 Jun 2021 | REST | ||
Sat, 5 Jun 2021 | OTHER | ||
Sun, 6 Jun 2021 | REST | ||
Mon, 7 Jun 2021 | OTHER | ||
Tue, 8 Jun 2021 | REST | ||
Wed, 9 Jun 2021 | Skendleby, N Lincs (Cottage behind Blacksmith's Arms) | 2.0 | 0:30:40 |
Thu, 10 Jun 2021 | Skendleby, N Lincs (Cottage behind Blacksmith's Arms) | 3.6 | 0:56:44 |
Fri, 11 Jun 2021 | Skendleby, N Lincs (Cottage behind Blacksmith's Arms) | 2.0 | 0:32:19 |
Sat, 12 Jun 2021 | REST | ||
Sun, 13 Jun 2021 | OTHER | ||
Mon, 14 Jun 2021 | Cull. Road/Viaduct (up and down)/Halifax Road/ Greenside Lane (08/11/2018) | 2.2 | 0:33:59 |
Tue, 15 Jun 2021 | OTHER | ||
Wed, 16 Jun 2021 | REST | ||
Thu, 17 Jun 2021 | OTHER | ||
Fri, 18 Jun 2021 | Cullingworth Rd/Viaduct/ Ling Bob roundabout/ Wilsden/Bents Lane/ Hallas Bridge (09/12/2018) | 4.2 | 0:55:39 |
Sat, 19 Jun 2021 | OTHER | ||
Sun, 20 Jun 2021 | REST | ||
Mon, 21 Jun 2021 | OTHER | ||
Tue, 22 Jun 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/ Bents Lane/Hallas Bridge (22/06/2021) | 8.8 | 2:12:20 |
Wed, 23 Jun 2021 | 2x OTHER | ||
Thu, 24 Jun 2021 | REST | ||
Fri, 25 Jun 2021 | OTHER | ||
Sat, 26 Jun 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 5-Rise Locks/ Back to 3-Rise Locks & over Bridge/Brown Cow/ Main Road all the way back home (25/08/2005) | 10.4 | 2:40:15 |
Sun, 27 Jun 2021 | OTHER | ||
Mon, 28 Jun 2021 | REST | ||
Tue, 29 Jun 2021 | OTHER | ||
Wed, 30 Jun 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/ Bents Lane/Hallas Bridge (22/06/2021) | 8.8 | 2:07:10 |
Thu, 1 Jul 2021 | OTHER | ||
Fri, 2 Jul 2021 | REST | ||
Sat, 3 Jul 2021 | OTHER | ||
Sun, 4 Jul 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/5-Rise Locks/ 2 Bridges (Swine Lane)/ Back to 3-Rise Locks & over Bridge/Brown Cow/ Main Road all the way back home (04/07/2021) | 14.1 | 3:41:10 |
Mon, 5 Jul 2021 | OTHER | ||
Tue, 6 Jul 2021 | REST | ||
Wed, 7 Jul 2021 | OTHER | ||
Thu, 8 Jul 2021 | Cullingworth Rd/Viaduct/ Stn Road/Old Allen Rd/ Back Lane/Shay Lane/ Crack Lane/Main Street/ Bents Lane/Hallas Bridge (23/02/2020) | 6.2 | 1:38:10 |
Fri, 9 Jul 2021 | OTHER | ||
Sat, 10 Jul 2021 | REST | ||
Sun, 11 Jul 2021 | OTHER | ||
Mon, 12 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/ Bents Lane/Hallas Bridge (22/06/2021) | 8.8 | 2:15:04 |
Tue, 13 Jul 2021 | OTHER | ||
Wed, 14 Jul 2021 | REST | ||
Thu, 15 Jul 2021 | OTHER | ||
Fri, 16 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/ Bents Lane/Hallas Bridge (22/06/2021) | 8.8 | 2:14:27 |
Sat, 17 Jul 2021 | OTHER | ||
Sun, 18 Jul 2021 | REST | ||
Mon, 19 Jul 2021 | OTHER | ||
Tue, 20 Jul 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 5-Rise Locks/ Back to 3-Rise Locks & over Bridge/Brown Cow/ Main Road all the way back home (25/08/2005) | 10.4 | 2:44:52 |
Wed, 21 Jul 2021 | OTHER | ||
Thu, 22 Jul 2021 | REST | ||
Fri, 23 Jul 2021 | OTHER | ||
Sat, 24 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/ Bents Lane/Hallas Bridge (22/06/2021) | 8.8 | 2:06:27 |
Sun, 25 Jul 2021 | OTHER | ||
Mon, 26 Jul 2021 | REST | ||
Tue, 27 Jul 2021 | OTHER | ||
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 | 2:35:00 |
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 | 2:21:55 |
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 | 3:48:05 |
Last edited: