IF statement help to determine active sprint

Hi all -- just starting to build a library of IF statements...

Looking for some help to build an IF statement to determine which Sprint is the current active sprint...

Basically, IF Today's date is between [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave it unchecked.

Can't figure out how to denote the between and make sure it allows for today possibly being the same as the start date or the end date.

Thanks so much in advance for any help on what I'm sure is something very simple!

Find more posts tagged with

Education

Formulas

IT & Operations

Comments

J. Craig Williams

=IF(AND(TODAY() >= ColumnSprintStartDate23, TODAY() <= ColumnSprintEndDate23), 1, 0)

for row 23.

Craig

Stacey Lopez

I didn't see this until just now; thank you so much for responding so quickly.

What joy a little checkmark can bring - lol

Works great!

J. Craig Williams

LOL

Now I know how Sankt Nikolaus felt/feels.

Craig