Hi, can anyone please advise me of the syntax required to amend the following code
=IF(AND(I4>=$H2,I4<=$I2),"For This Period","Not In This Period") to also check if I4 is blank and if so to return a blank field i.e. no text as opposed to returning either "For This Period" or "Not In This Period")
Many thanks in advance Rob
N.B. I have attached an example workbook
Bookmarks