Count if singular date falls between a list of date ranges


Hi community,

I want to check if a singular date falls between any of a list of different date ranges from another sheet.

E.g. If 01/08/23 is found in any of a list of start / finish date ranges, I want to flag or count.

Any suggestions?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!