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