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