Generate current month

[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?

 

[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<>""))

 

[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).

 

[Brandy]

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

 

[Frank Kabel]

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

 

[Brandy]

That was great, Frank. Thank you.

-----Original Message-----
Hi
yeah is missed a bracket. So try:
=SUMPRODUCT(--(MONTH(A6:A500)=MONTH(TODAY())),--