fiscal quarter

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...

Here are my three formulas: in R6: =IF(K6="","",CHOOSE(MONTH(K6),2,2,2,3,3,3,4,4,4,1,1,1)) in Q6: =IF(K6="","",YEAR(K6)+IF(MONTH(K6)>=10,1,0)) in P6: =IF(Q6="","",("Q"&R6&" "&"FY"&Q6)) R6 finds the Fiscal Quarter of the date in K6 Q6 finds the Fiscal Year of K6 P6 combines the two results...

Formula for our Our fiscal first quarter 2015 (ending <chron style="color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px;">April 30, 2014</chron>) and fiscal year 2015 (ending <chron style="color: rgb(0, 0, 0); font-family: Arial, Helvetica...

Hello, I recently started watching the amazing ExcelisFun power pivot videos by Mr. Girvin and have been having a blast learning about all of the capabilities and ease of use. I have two questions about the date table that I really need some help with. I've been searching the internet for a...

Hi, on the back of another thread I would like to use the similar formula =IF(MONTH(A4)>9,YEAR(A4)&"-"&RIGHT(YEAR(A4)+1,2),YEAR(A4)-1&"-"&RIGHT(YEAR(A4),2)) However my financial year runs slightly different, for example: Q1 = 1/10/2013 - 31/12/2013 Q2 = 1/1/2014 - 31/3/2014 Q3 = 1/4/2014 -...

I'm attempting to create a table that will automatically update the previous fiscal quarters based on a single input value. My goal is that I can put the current fiscal quarter and year into one input cell (A2) and that the table will count down from there. Thanks for the help! Here is how I'd...