Get instant live expert help on I need help with fiscal quarter dates

I have a range of names in rows and dates in multiple columns that they attended training. At the end of each row, I need 4 extra columns that work out if any of the dates in the row occurred in each fiscal quarter.

Issue Fiscal calendar July 1- June 30 A quarter consists of 3 months I need the following dates to give back a specific month. Date X years Return this month Q1 July 1- Aug 15 July Q1 Aug 16-Sept 30 Oct Q2 Oct 1- Nov 15 Oct Q2 Nov 16- Dec 31 Jan Q3 Jan 1 - Feb 15 Jan Q3 Feb 16-Mar 31 Apr Q4 Apr 1-May 15 Apr Q4 May 16-Jun 30 July

I am working on a pivot and I have one column as dates, instead of dropping the dates it drops in the year the month and the quarter, how can I fix this ?

I am trying to figure out how to take a fiscal year field and month field and create a date in xx/xx/xxxx format in Excel. The fiscal year is October -September. If the month is October November or December, the date will correspond to the previous year of the fiscal year (ie if the month is "October" and the fiscal year is 2010- the date would read "10/1/2009").

I am Building a Spreadsheet where Column A is dates that I would like to change colors every quarter, In column B I would like a drop down to that will reset Column A to white. So column A will change colors every quarter and columns B,C,D will be drop downs that reset it to white once the task was accomplished for the Quarter. A d be Jan-Mar, Apr-June, July-Sept, and Oct-Dec.