Countif date range, two columns

Options
edited 03/09/23

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.

• ✭✭✭✭✭✭
Options

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)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• edited 03/09/23
Options

Thanks. Perfect! :)

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!