IF OR Formule rewritten

[MrGeek1]

Hi all,

I need your help on this one. I have inputs in my IF OR logicals as different dates (20 in total). Because of these 20 inputs the formula gets jammed and if you want to change the dates to 12 you need to do this manually and it takes some time. So I want to have a formula or code that selects these dates based on the exit dates fields and can be adjusted easier. Could you help me out? Thanks!

Date 31-03-2020 30-06-2020 --------> and so forth
CF 100,000 120,000

 

[Dave Patton]

Please post with the Forum's XL2BB a concise example and expected results.

The array of numbers can be created quite easily.
For example, put the Dates in K1:K20. Put K1:K20 into formula; press F9 to convert K1:K20 to an array of numbers.

T202010a.xlsm
	I	J	K
1	31-Dec-22		31-Mar-20
2	TRUE		30-Jun-20
3			30-Sep-20
1c

Cell Formulas
Range	Formula
I2	I2	=OR(I1={43921;44012;44104;44196;44286;44377;44469;44561;44651;44742;44834;44926;45016;45107;45199;45291;45382;45473;45565;45657})
K2:K3	K2	=EOMONTH(K1,3)