Return a value if a cell date is between 2 dates
I want to automate one of my sheet summary by retrieving the Sprint# based on today's date. (When today's date is between the beginning and end of a sprint, I want the sprint# to be retrieved in the Automated Sprint field of the summary sheet).
I have tried to use =INDEX([Sprint#]:[Sprint#], MATCH([Sprint start date]:[Sprint start date] <= [Today's date]:[Today's date]) * ([Sprint end date]:[Sprint end date] >= [Today's date]:[Today's date], 0)) but it get #UNPARSEABLE
Any help will be greatly appreciated