Quarterly Lookup

Hi, 

 

I'm trying to look up the last day of the Quarter for a LI, and then also find the average of a Quarter.  How would I go about doing so? 

 

Thank you

Answers