Change <60 Days to search by month

tgattsh

So I have this formula which searches the past 60 days.

=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60))

I want to change it to search my date range {18b Issues Range DT} and show everything in the month of Jan 2024. How would I change this? Any help would be appreciated!

tgattsh

Oh That's easy. Try this...

=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))

Happy to help...

tgattsh

Oh That's easy. Try this...

=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))

Happy to help...