financial year

  1. A

    Extracting Fiscal Year / Financial Year based on the Quarters using the "IF" function with nested "OR" Function.

    <tbody> Date Quarter FY Intended Results in column "C" 15-07-2018 1 1905 2018 10-09-2018 1 1905 2018 04-11-2018 2 1905 2018 14-03-2019 3 1905 2018 10-05-2019 4 1905 2018 20-12-2018 2 1905 2018 Detail...
    • Asadmir27
    • Thread
    • extracting fiscal year financial year fiscal year quarters year
    • Replies: 1
    • Forum: Excel Questions
  2. R

    Change Date to Financial Year

    Hi, Help Please. Trying to change the date into financial year Apr-Mar. I'm close and using the below formula; MID(YEAR(DATE(YEAR(G5),MONTH(G5)+(10-1),1)),3,2)-1&"/"&RIGHT(YEAR(DATE(YEAR(G5),MONTH(G5)+(10-1),1)),2) with the date in G5 in format xx/xx/xxxx. The problem i have is dates for...
  3. P

    DAX formula to calculate the full year total for the previous financial year, based on page filter selection

    I am trying to calculate Total Revenue for the full financial year (ending 30 Jun) preceding the month selected in a filter using my Data Table's Month End field. I've wasted a lot of time on something which seems (and probably is) straight forward for the experienced DAX user (I'm a relative...
    • peejay
    • Thread
    • dax financial year full year prior year
    • Replies: 3
    • Forum: Power Tools
  4. C

    Financial/Fiscal Year

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

    CountIF VBA, financial year question

    Afternoon all, I have hit a definite block in my understanding of VBA. I have been trying to get it to do something I would assume to be simple all day, but don't seem to have the knowledge or understanding to even get close. I would be really grateful for any help that you could give (or...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top