If and statement

trebor1956

Board Regular
Joined
Jul 2, 2015
Messages
70
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.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

fhqwgads

Board Regular
Joined
Jul 17, 2018
Messages
194
Office Version
  1. 2019
Platform
  1. Windows
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
Code:
=MONTH(A1)
 
Last edited:

trebor1956

Board Regular
Joined
Jul 2, 2015
Messages
70
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
Code:
=MONTH(A1)

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

Watch MrExcel Video

Forum statistics

Threads
1,122,421
Messages
5,596,033
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top