date and periods

[anillinda]

I would like the following values to populate based on dates:
if date is 08-31-18 then 1
if date is 09/30/2018 then 2
.................................................................................
if date is 07/31/2019 then 12

What is the best way to do it?
the if formula becomes too complex.
thanks

 

[jtakw]

Hi,

Assuming the Day of month is Not a factor:

Book1
	A	B
1	8/31/2018	1
Sheet247

Cell Formulas
Range	Formula
B1	=CHOOSE(MONTH(A1),6,7,8,9,10,11,12,1,2,3,4,5)