Formula required to show the 13 'events' within a year once the event date is reached.

[Red over White]

I am trying to come up with a formula whereby only when you get to the date in column F4 onwards does the figure in column H on the same row appears.

The figures in column H is a cumulative total of B4 based on the number of times the dates in Column D is/are either greater than a date in column F AND less than or equal to the date in the row below. The dates in column D are simply a recurring 28 days after the last one. In most cases there is just one 'event' in each period, but there will always one occasion when you get two events in a period and this one is highlighted in green.

Thanks in advance

 

[StephenCrump]

I'm not sure I understand the question about having the number "appear" only once "the event date is reached"?

But this replicates your results in column H, which is perhaps what you are asking?

	A	B	C	D	E	F	G	H
1
2
3						5 Apr 2024
4		10		1 May 2024		5 May 2024		10
5				29 May 2024		5 Jun 2024		20
6				26 Jun 2024		5 Jul 2024		30
7				24 Jul 2024		5 Aug 2024		40
8				21 Aug 2024		5 Sep 2024		50
9				18 Sep 2024		5 Oct 2024		60
10				16 Oct 2024		5 Nov 2024		70
11				13 Nov 2024		5 Dec 2024		80
12				11 Dec 2024		5 Jan 2025		90
13				8 Jan 2025		5 Feb 2025		110
14				5 Feb 2025		5 Mar 2025		120
15				5 Mar 2025		5 Apr 2025		130
16				2 Apr 2025
Sheet1

Cell Formulas
Range	Formula
F3:F15	F3	=EDATE(DATE(2024,4,5),SEQUENCE(13,,0))
D4:D16	D4	=SEQUENCE(13,,DATE(2024,5,1),28)
H4:H15	H4	=H3+B$4*COUNTIFS(D$4#,">"&F3,D$4#,"<="&F4)
Dynamic array formulas.

 

[Red over White]

Thanks your formulas are what I needed, I have never used sequences before. Sorry for the lack of clarity around the word 'appear', putting if(today()>=F4 and ,"") around the formula in H4 solves that issue.

Thanks again