Then try this for Average QTD in G7 (ps: calculation base on exact number of days between each quarter, leap year taken care as well)
Formula:
=D7/(EOMONTH(DATE(YEAR(A7),ROUNDDOWN((MONTH(A7)-1)/3,0)*3+3,1),0)-DATE(YEAR(A7),ROUNDDOWN((MONTH(A7)-1)/3,0)*3+1,1)+1)
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Bookmarks