• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Date range and If function

    Hi All I am struggling with a formula to return me the year of assessment if the date falls between such and such date. I used the below. But I cannot continue to add more years... =IF(AND(C2>=$H$14,C2<=$H$25),"YOA 2001/2002",IF(AND(C2>=$H$26,C2<=$H$37),"YOA 2002/2003"))...
Back
Top