Countif date range, two columns

Stian Johansen

Hello,

I want to find an formula who can count if todays date is inside the date range of two columns. Have already made the formula for one date range, but can't get it to work with two. Hope somebody would be able to help me

=COUNTIFS({Utf-start-utb}; IFERROR(DAY(@cell); 0) = DAY(TODAY()); {Utb-montør}; Kontakt@row)

In this formula I count “utførelse start” if its match todays date, and “montør” matches another column. As for now It doesnt match the 8th of March, because “utførelse start” is only one value - not an range. On the first row I want it to give me the value of one booking if inside start and end date.

Jeff Reisman

@Stian Johansen

Try this. The logic is: Count the row if the utførelse start is less than or equal to today, the utførelse slutt is greater than or equal to today, and the Montør equals the Kontakt on this row.

=COUNTIFS({Utf-start-utb}; @cell <= (TODAY()); {Utf-start-utb}; @cell >= (TODAY()); {Utb-montør}; Kontakt@row)

Jeff Reisman

@Stian Johansen

Try this. The logic is: Count the row if the utførelse start is less than or equal to today, the utførelse slutt is greater than or equal to today, and the Montør equals the Kontakt on this row.

=COUNTIFS({Utf-start-utb}; @cell <= (TODAY()); {Utf-start-utb}; @cell >= (TODAY()); {Utb-montør}; Kontakt@row)

Stian Johansen

Thanks. Perfect! :)

PS: Out of curiosity, if I wanted to count by tomorrows date - which changes should I do then? @Jeff Reisman