Help!! Using 2 date fields to determine Month - Multiple "ifs & Ands"..........

I have been trying since yesterday to come up with the correct formula for identifying the correct month using 2 date fields. The formula appears right but it doesn't work.

Below is the formula I'm using but it just shows Jan & Feb. I eventually want to use it in determining all the months and quarters. Can anyone help?? Below is the Formula.

=IF(AND(B6=DATEVALUE("1/1/15"),D6=DATEVALUE("1/31/15")),"January",IF(AND(B6=DATEVALUE("02/01/15"),D6=DATEVALUE("02/29/15")),"February","Special Report Period"))

Are you trying to identify the month in a given cell? It's unclear what your formula is trying to do.

Welcome to the forum.

If you want to check for all 12 months, a long IF statement almost certainly isn't the best way to do it - even worse if you eventually want to identify quarters as well. As ChemistB says, let us know what it is you're actually trying to do and we should be able to come with a way of doing it. The easiest way to do this is normally to post a sample file showing the data you have and the results you want (make sure you don't include any confidential information). To attach a file, click 'Go Advanced' under the reply box and then use the paperclip icon.

The spreadsheet pulls data from a period of time to produce a report using only the date range identified by cells B6 and D6. What I'm trying to also is create a cover page for the report so when printed, the report will have a cover page showing the month or Qtr the period is for. IF not one of those standard dates, it will just reflect "Special Report Period".

I hope this helps. I kind of figured there was an easier way to do it but it is beyond my skill level. Always learning...

Okay, so the extent of the report is given by B6 and D6 (first and last date)?
Maybe something like this?

=IF(MONTH(B6)=MONTH(D6), TEXT(B6, "mmmm"), LOOKUP(MONTH(B6), {1,4,7,10}, {"1st Quarter", "2nd Quarter", "3rd Quarter", "4th Quarter")

Having said that a multiple IF might not be the best solution I think this will do what you want:

Formula:

Please Login or Register  to view this content.

The formula first checks that D6 is after B6 - if not, you get an error message saying the end date has to be after the start date.
Then it checks for a monthly report (B6 = 1st of month and D6 is the last day of the same month).
Then it checks for each quarter (B6 = 1st of month and D6 = end of third month after that and the B6 month = 1/4/7/10).
The quarterly checks assume that Q1 = Jan-Mar, Q2 = Apr-Jun, etc. If your Q's are different, amend the months appropriately.

Hope that does what you want.

Edit: amended to put 'TEXT(B6,"mmmm")' instead of just 'B6' for the monthly report.

You're welcome, and thanks for the rep and the kind comments with it.