Forum Discussion
Percent of growth based on percent of fiscal year?
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....
Hello Just_Jenn,
Would it be more appropriate to compare 54% through the current YTD data with 54% through the previous YTD data?
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
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....
Thank you AshaKantaSharma ! That is EXACTLY what I needed.
Alternatively:
=1-(A6/B6*365/(TODAY()-DATE(2019,4,1)))being 1-(Current / Prior Year) X (365 / Number of days passed)
Thank you Riny_van_Eekelen! That is a nicer looking formula, it doesn't give me the correct negative though.
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).
