Forum Discussion

Just_Jenn's avatar
Just_Jenn
Copper Contributor
Jan 14, 2020
Solved

Percent of growth based on percent of fiscal year?

I'm not really sure what I'm looking for exactly so here is the gist of it.... I have current YTD data and previous YTD data along with a percentage of growth formula.  The growth is currently all n...
excel
Formulas and Functions
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Jan 14, 2020

    Hey Just_Jenn 

     

    Please see the attached sheet if it helps as i have prepared the sheet taking into account start of FY from 1st April to 31st March

     

    Formula =(A6-((DATE(2019,4,1)-TODAY())*AVERAGE(B6/365)*-1))/((DATE(2019,4,1)-TODAY())*AVERAGE(B6/365)*-1)

     

    Hope it is an automated single formula as required by you to give a more realistic view of current status of growths. 

     

    Hope it helps...

     

    Thanks and have a great time ahead....

Just_Jenn's avatar
Just_Jenn
Copper Contributor
Jan 14, 2020

I could take the current YTD data and simply compare it to the totals through January of last year, but then I would have to do that again in Feb, Mar, Apr, etc.  I has hoping there was some type of dynamic formula that could just use the percentage of the current year to estimate the growth. PReagan 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 14, 2020

Just_Jenn 

I would compare the current YTD to the Previous year in relation to the number of days (weeks, months) passed during the current year. For instance, if your current YTD is 60 days into the current year, your formula could be (Current / 60 ) / (Prior Year / 365). Alternatively, (Current / Prior Year) X (365 / 60).