Return Value if Date Falls between Two dates


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!