IF AND to define which date category

[NJS1982]

Hi all, I have a list of dates and I am trying to state (TEXT) which quarter of the year that they all fall into.
My formula is this:

=IF(AND(B47>="30/1/2017"+0,B47<="31/3/2017"+0),"Jan-Mar '17",
IF(AND(B47>="1/4/2017"+0,B47<="30/6/2017"+0),"Apr-June '17",
IF(AND(B47>="1/7/2017"+0,B47<="30/9/2017"+0),"Jul-Sept '17",
IF(AND(B47>="1/10/2017"+0,B47<="31/12/2017"+0),"Oct-Dec '17",
IF(AND(B47>="1/1/2018"+0,B47<="31/3/2018"+0),"Jan-Mar '18",
IF(AND(B47>="1/4/2018"+0,B47<="30/6/2018"+0),"Apr-June '18",
IF(AND(B47>="01/7/2018"+0,B47<="30/09/2018"+0),"Jul-Sept '18",
IF(AND(B47>="01/10/2018"+0,B47<="31/12/2018"+0),"Oct-Dec '18",
IF(AND(B47>="1/1/2019"+0,B47<="31/3/2019"+0),"Jan-Mar '19","")))))))))

It works fine, BUT, all of my cells with a date of 30/06/2017 or 31/03/2017 do not work and are blank. Can anyone tell me why this is?
The cells are not formatted any different, the return is simply blank? I can't see an error with the formula and all of the others work...
Is it something to do with the '=' part of the formula? I need to include those dates that fall onto the first and last day of the quarters...

Thanks!

 

[njimack]

=CHOOSE(ROUNDUP(MONTH(B47)/3,0),"Jan-Mar '","Apr-Jun '","Jul-Sep '","Oct-Dec '")&TEXT(B47,"yy")

 

[NJS1982]

=CHOOSE(ROUNDUP(MONTH(B47)/3,0),"Jan-Mar '","Apr-Jun '","Jul-Sep '","Oct-Dec '")&TEXT(B47,"yy")

Why do you have to be so clever?!? Many thanks, works perfectly and looks much neater!!