I am looking to just calculate the column in red below (Column E) in a basic excel spreadsheet.
So I have the information in column A which is converted from date to fiscal quarter for column B. The same applies for column C which is converted into fiscal quarter (Column D). The end result is the difference between column B and column D to get the number of quarters. Do you think this is possible please?
I am currently manually entering the red E column as I get hung up when the quarters cross years.
Any help would be GREATLY appreciated!
<tbody> </tbody>
So I have the information in column A which is converted from date to fiscal quarter for column B. The same applies for column C which is converted into fiscal quarter (Column D). The end result is the difference between column B and column D to get the number of quarters. Do you think this is possible please?
I am currently manually entering the red E column as I get hung up when the quarters cross years.
Any help would be GREATLY appreciated!
First Reported Date (A) | First Reported Qtr (B) | Target Completion Date (C) | Target Completion Qtr (D) | Duration to Remediate (Quarters) (E) |
30/03/2016 | Q2 F16 | 19/05/2016 | Q3 F16 | 1 |
30/03/2016 | Q2 F16 | 20/06/2016 | Q3 F16 | 1 |
18/08/2014 | Q4 F14 | 31/12/2015 | Q1 F16 | 5 |
28/03/2016 | Q2 F16 | 31/12/2016 | Q1 F17 | 3 |
<tbody> </tbody>