if you have the first day of the month in D11:O11 then format that cell to just display months.
Use this formula for D12 and drag it across.
Formula:![]()
=COUNTIFS($D$2:$O$9,">"&D11,$D$2:$O$9,"<"&EOMONTH(D11,0))
if you have the first day of the month in D11:O11 then format that cell to just display months.
Use this formula for D12 and drag it across.
Formula:![]()
=COUNTIFS($D$2:$O$9,">"&D11,$D$2:$O$9,"<"&EOMONTH(D11,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks