Wish I could help. I'm tied up today.
Thanks again for quick solving my problem.
A follow up question:
What if I change the formula of annual growth to:
Last day of year / Last day of previous year - 1 (if last day of previous year is not available, then use the first day of current year)
In this sample data, it should be:
2010: 10/5-1 =1
2011: 7/10-1 = -0.3
2012: 8/7-1 = 0.14