Valid Prices

[ricafonyat]

Let me know if you can help me with the following problem:
I have a list of prices that are valid from certain dates (range B3:C5) and there is also a limit date from which they are no longer valid (cell: B8)
In the range E2:R3 the desired final result is presented.

Mr Excel Post.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		Valid From Date	Prices		Jan 31 - 2024	Feb 29 - 2024	Mar 31 - 2024	Apr 30 - 2024	May 31 - 2024	Jun 30 - 2024	Jul 31 - 2024	Aug 31 - 2024	Sep 30 - 2024	Oct 31 - 2024	Nov 30 - 2024	Dec 31 - 2024	Jan 31 - 2025	Feb 28 - 2025
3		Feb 01 - 2024	80.000			80.000	80.000	80.000	80.000	90.000	90.000	90.000	90.000	100.000	100.000	100.000	100.000	0
4		Jun 01 - 2024	90.000
5		Oct 01 - 2024	100.000
6
7		Final Date
8		Jan 31 - 2025
9
10
11
Planilha1

Any help is greatly appreciated

 

[DanteAmor]

Try the following formulas

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		Valid From Date	Prices		31/01/2024	29/02/2024	31/03/2024	30/04/2024	31/05/2024	30/06/2024	31/07/2024	31/08/2024	30/09/2024	31/10/2024	30/11/2024	31/12/2024	31/01/2025	28/02/2025
3		01/02/2024	80000			80000	80000	80000	80000	90000	90000	90000	90000	100000	100000	100000	100000	0
4		01/06/2024	90000
5		01/10/2024	100000
6
7		Final Date
8		31/01/2025
9
10
Hoja2

Cell Formulas
Range	Formula
E2	E2	=EOMONTH(DATE(YEAR(B3),MONTH(B3)-1,1),0)
F2:R2	F2	=EOMONTH(E2+1,0)
E3:R3	E3	=IFERROR(IF(E2<=$B$8,VLOOKUP(E2,$B$3:$C$5,2,1),0),"")