Quote Originally Posted by sktneer View Post
Not sure why Sucuri WebSite Firewall is not allowing me to post the formula here....
Please find the attached workbook to see if this is what you are trying to achieve.
Hi Sktneer,

Yes this works like how i needed it. Only one thing though. Is it possible for the each Q1 to calculate as the last day of the Quarter instead of the first day?

Kind Regards,
Mark.