How can I create an average with a formula for YTD 2016, through April?
Here you go. Let me know if that works. Change year from 2011 to 2016 in your data.
One more helpful link: Year to Date (YTD) from Previous Year and Fiscal Year
Retrieving data ...