# Multiple IFs help

Folks, if I use the below formulas individually they work fine:

=IF(AND([Due Date]69 >= "01/01/18", [Due Date]69 <= "01/31/18"), "January", "-")

or

=IF(AND([Due Date]69 >= "02/01/18", [Due Date]69 <= "02/28/18"), "February", "-")

I have tried to put them together like this:

=IF(AND([Due Date]69 >= "01/01/18", [Due Date]69 <= "01/31/18"), "January", "-", IF(AND([Due Date]69 >= "02/01/18", [Due Date]69 <= "02/28/18"), "February", "-")

and many other variations and cannot get it to work.

The whole idea is to identify which month the "Due Date" is, if the date entered is: 01/015/18 the result should be "January" or if the "Due Date" is changed to 02/20/18 it would display " February, if 03/10/18 is entered the result would be "-"

For simplicity I have only put two months but it is meant to be for the entire year.

Regards!

Sumeluar

• I think your issue might be in that you've combined the IF statements, but haven't nested them. Each IF statement should be followed by the next IF statement instead of the else... you have "-" as your else statement and its smattered in and among your formula. Your "-" should go at the end of the entire statement and then you have to close each IF statement at the end which is why there are 2 closing parenthesis. Try it out and let me know if that works.

=IF(AND([Due Date]69 >= "01/01/18", [Due Date]69 <= "01/31/18"), "January", IF(AND([Due Date]69 >= "02/01/18", [Due Date]69 <= "02/28/18"), "February", "-"))

• When nesting IF functions, you place the next IF statement in the [value if false] position (where you have your "-").

=IF(AND([Due Date]69 >= "01/01/18", [Due Date]69 <= "01/31/18"), "January", IF(AND([Due Date]69 >= "02/01/18", [Due Date]69 <= "02/28/18"), "February", "-"))

• So concisely stated. • I didn't see your comment before mine. Haha. I had opened it to answer earlier in the morning, but I got crazy busy for a while and didn't think to refresh before typing my reply.

• Thanks a bunch guys, now I know how to do it.

Regards!

Sumeluar

•  You're welcome!