With week number in A1 and year in B1 try: =MONTH(DATE(B1,1,A1*7-2)-WEEKDAY(DATE(B1,1,3))) « Combine stacked and unstacked columns in single chart Hide 0-value data labels in an Excel Chart »