Date Range Formula Help


I am trying to use a formula to find the number of confirmed and requested booking status within a period of time.

So for example for finding the number of confirmed booking statuses from today until the end of the list I used the formula below which gave me the correct value:

=COUNTIFS({AZA JOURNEY - Itinerary & Booking Range 1}, "Confirmed", {AZA JOURNEY - Itinerary & Booking Range 2}, >=TODAY(0))

So my question is how the formula should be in order to find the confirmed booking status separately for 2023, 2024 and 2025?

Best Answer

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    Answer ✓

    @Ilias That does look right, and in sheet summary, you would be able to write this formula, changing the dates for the specific year and have that sum per year.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!