try this:
=SUMPRODUCT(--(A1:A33>TODAY());--(A1:A33<DATE(YEAR(TODAY());1+MONTH(TODAY());1)))
If you need to calulcate curent date too put >= in first formula.
Also change ; to , if needed and extend range
try this:
=SUMPRODUCT(--(A1:A33>TODAY());--(A1:A33<DATE(YEAR(TODAY());1+MONTH(TODAY());1)))
If you need to calulcate curent date too put >= in first formula.
Also change ; to , if needed and extend range
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks