• 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


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

Blank Cell with Date value not in range

im trying to create a formula to blank any cell in column A6:A36 if this cell value isn't in the range of the " J12 - J13 " date cells

I managed to get it in a part but sometimes when I choose for example date start July 5 to July 11 it shows me dates after July 11

i have attached the sheet with progress I did so far

i need help to find a fix for that , thanks in advance