Generate current month

B

Brandy

=SUMPRODUCT((TEXT(A6:A500,"mmm")="jul")*1)

is what I was given to get referrals in a current month.
I'm setting up a general program so that it is easy to use
for my co-workers and supervisors.

Is there a way to insert something for "jul" that will
enter the current month on its own?
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((TEXT(A6:A500,"mmm")=TEXT(TODAY(),"mmm"))*1)

Though I would use:
=SUMPRODUCT(--(MONTH(A6:A500)=MONTH(TODAY()),--(A6:A500<>""))
 
D

Dave Peterson

Maybe you could put a July date in a cell.

=SUMPRODUCT((TEXT(A6:A500,"mmm")=text($a$1,"mmm"))*1)

But if you change the date in A1, your results will change (which may be a good
thing).
 
B

Brandy

Thanks Frank - The one you said you would use did not work
though... the top one did.
 
F

Frank Kabel

Hi
yeah is missed a bracket. So try:
=SUMPRODUCT(--(MONTH(A6:A500)=MONTH(TODAY())),-- (A6:A500<>""))
 
Top