Hi, Please can someone help me with allocating a specific date into a quarter? The 1st quarter should start on August 1st and the 4th quarter finish on July 31st:

Quarter 1: August 1st - October 31st
Quarter 2: November 1st - January 31st
Quarter 3: February 1st - April 30th
Quarter 4: May 1st - July 31st

Unfortunately I seem to be unable to upload an example, so below is a very rough summary of what I'm struggling with.

Date Quarter Notes
02/08/2016 B1 should read 1
03/12/2016 B3 should read 2
14/02/2017 B4 should read 3
10/06/2017 B5 should read 4


Many thanks.
Jon