See if this works. It appeared you had cell references wrong in your instructions but i think i put together what you meant . You will notice that you get the word false in cell J4. based on the data in your sheet it says it should be 5-Sep, but based on the logic you provided it does work out. Step through that and see what you think. Maybe i am not Cyphering your instructions correctly.
Bookmarks