Date Range Formula Help

Ilias

Hey,

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?

Colleen Patterson

@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.

Ilias

So I have just used the below and seems that it works:

=COUNTIFS({AZA JOURNEY - Itinerary & Booking Range 1}, "Confirmed", {AZA JOURNEY - Itinerary & Booking Range 2}, >=DATE(2023, 1, 1), {AZA JOURNEY - Itinerary & Booking Range 2}, <=DATE(2023, 12, 31))

Please confirm if both of them seem right.

Thanks!

Colleen Patterson

@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.

Ilias

Thanks @Colleen Patterson