If and statement

[trebor1956]

I have start date of month in cell B1 and end date of month in B2 for April and the number 1 in B3

I have start date of month in cell C1 and end date of month in C2 for May and the number 2 in C3
etc through to march the next year

Todays date calculated via Today() is displayed in A1

I would like a formula to check if A1 is between B2 and B3 etc through to M2 and M3 and wherever it fits then display the appropriate number from B3 through to M3.
In other words find the number of the month corresponding to todays date.

I seem to be going round in circles so any help would be greatly appreciated.
​

 

[fhqwgads]

I would like a formula to check if A1 is between B2 and B3 etc through to M2 and M3 and wherever it fits then display the appropriate number from B3 through to M3.
In other words find the number of the month corresponding to todays date.

do you need the formula to do those things for a reason or do you just need the month of the date in A1?
you can just use

=MONTH(A1)

 

[trebor1956]

do you need the formula to do those things for a reason or do you just need the month of the date in A1?
you can just use

=MONTH(A1)

I just need the number of the month but April as month 1, May month 2 etc.

 

[FormR]

I just need the number of the month but April as month 1, May month 2 etc.

Hi, you could try:

=MONTH(EDATE(A1,-3))

 

[trebor1956]

Brilliant, thank you...