Return Value if Date Falls between Two dates

Options

Hi, below is my Pay Period reference sheet. In another sheet, I have a column with one date by task. In this sheet, which formula I can us to find in which period this task happened related to my pay period? By example, I would like to say ''If this task happened on Sunday May 10th , my " Numéro de période" should be 2.

Thanks a lot


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!