Skip to main content
Question

Date falls in a range every year

E
Forum|alt.badge.img+5
  • E_K
  • Known Participant
  • 16 replies

I would appreciate any input for such task:

I need to determine if TODAY() falls within a date range, say from March 1st to October 31st, regardless of the year.

So I need to compare TODAY() with start date and end date without the year, but only with day and month.

I cannot figure out how to do it.

Thanks for any thoughts

2 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Does this look right?

AND(
  OR(
    IS_SAME(
      Today,
      DATETIME_PARSE(
        '01 Mar ' & YEAR(Today)
      ),
      'day'
    ),  
    IS_AFTER(
      Today,
      DATETIME_PARSE(
        '01 Mar ' & YEAR(Today)
      )
    )
  ),
  IS_BEFORE(
    Today,
    DATETIME_PARSE(
      '01 Nov ' & YEAR(Today),
      'DD MMM YYYY'
    )
  )
)

And I’ve set it up here for you to check out!

 
Adam, Consultant @ thetimesaving.company
E
Forum|alt.badge.img+5
  • E_K
  • Author
  • Known Participant
  • 16 replies
  • April 7, 2025

Thank you ​@TheTimeSavingCo , that’s exactly what I was looking for.

Appreciated your help very much indeed

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo

Reply


Most helpful members this week

Terms & Conditions