Fonction Date + Counif

azerty64

Hello everyone,

I am looking for a formula allowing me to return the projects in progress during the month. In my logic the formula gives this:

IF(AND({2022 Plage 1}@row >=[Colonne5]2; {2022 Plage 1} <= [Colonne5]3); COUNTIF({2022 Plage 2}; [Colonne principale]@row); "")

With :

[Colonne5]2 =DATE(YEAR(TODAY()); MONTH(TODAY()); 1)

[Colonne5]3 =IFERROR(DATE(YEAR(TODAY()); MONTH(TODAY()) + 1; 1); DATE(YEAR(TODAY()) + 1; 1; 1)) - 1

But it doesn't work... So can you help me please ?

Sorry for my english

Genevieve P.

Hi @azerty64

Instead of doing an IF statement with an AND to look across sheets, I would put the date criteria within the COUNTIF and make it a COUNTFS, plural.

Try this:

=COUNTIFS({2022 Plage 1}; @cell >=[Colonne5]2; {2022 Plage 1}; @cell <= [Colonne5]3; {2022 Plage 2}; [Colonne principale]@row)

This assumes {2022 Plage 1} is a Date Column referenced. Let me know if this makes sense and works for you!

Cheers,

Genevieve