Finding matching month name for IF criteria

[Centaro1]

Hello again, everyone!

I am trying to define a criteria for an AVERAGEIFS function that checks whether the month of a date formated “DD-MMM-YYYY” is the current one. I have tried several things, but without success.

Let’s assume my dates are in the range A1:A3.

Knowing

=text(A1;“MMM”)

will return “JAN” or “FEB” or whatever, and

=SEARCH(TEXT(A1;“MMM”);TEXT(TODAY();“MMM”))

will return “1” only if the month is a match, I tried stuff like:

=AVERAGEIFS(A1:A3;SEARCH(TEXT(;“MMM”);TEXT(TODAY();“MMM”))

but it won’t assume that the first variable for the first =text should be the cell it is looking up, or

=AVERAGEIFS(A1:A3;SEARCH(TEXT(TODAY();“MMM”);))

but it won’t assume that the second variable for =search should be the cell it is looking up.

I have also tried with find, but encountered the same limitations. Does anyone know the right syntax or an alternative that doesn’t involve creating an extra column with the separate value for “MMM” for every date?

Thanks in advance

[Centaro1]

I actually wanted to find a good way to account for data from only the current month.

=AVERAGEIFS(A1:A3;">"&(EOMONTH(TODAY();-1))

This is how I did it.

[karolus]

@Centaro1

=AVERAGEIFS(A1:A3;">"&(EOMONTH(TODAY();-1))

i’m missing some other range probably before A1:A3

=AVERAGEIFS( ???? ; A1:A3;">"&(EOMONTH(TODAY();-1))

[erAck]

And for only one criterion use AVERAGEIF() instead of AVERAGEIFS().