How do I display the current quarter based on the date entered in another cell.

[pjfreeman]

I need a formula that will display the current quarter based on the date entered in another cell.

For example: if I have 08/14/14 in cell F7, I want 07/01/14 to 09/30/14 to display in cell B20. In cell B21 I want the following quarter dates to show (10/01/14 to 12/30/14). In cell B22 04/01/15 to 06/30/15 should show and in cell B23 I want 07/01/15 to 09/30/15.

The quarter dates should change with each date that is entered in cell F7, no matter what date is entered.

How is this done? I am using Excel 2010

 

[RickXL]

I was surprised that yours wasn't correct to begin with!

You were surprised!!!

Yes, I know about the "3". There are simplifications that can be made but I applied the "If it ain't broke, don't fix it" rule.

I concentrated more on using the cells specified by the user and also getting the date format as requested.