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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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.
Solved by I. C. in 11 mins
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
Solved by V. B. in 19 mins
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 ?
Solved by E. E. in 14 mins
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").
Solved by Z. H. in 26 mins
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.
Solved by Z. Q. in 28 mins