Whats the formula to find todays date between a range of dates to provide a value?

Majduleen

i need a formula to find todays date between the start date and end date, then provide the current sprint

bisaacs

Hey @Majduleen,

INDEX/COLLECT should provide what you're trying to do:

=INDEX(COLLECT([Primary Column]:[Primary Column], [Start Date]:[Start Date], <=TODAY(), [End Date]:[End Date], >=TODAY()), 1)

Hope this helps!

bisaacs

Hey @Majduleen,

INDEX/COLLECT should provide what you're trying to do:

=INDEX(COLLECT([Primary Column]:[Primary Column], [Start Date]:[Start Date], <=TODAY(), [End Date]:[End Date], >=TODAY()), 1)

Hope this helps!

Majduleen

worked perfectly! thank you!