Sunny, This is perfect and the explanation makes it clearer for me. Thanks, Diane
Hi Sunny, If column H does not have a date I also need the cell with the formula to be blank. Thanks
Hi Sunny, The above formula does the trick. I am having a hard time putting this in a sentence so I understand how the formula works. The part...
Hi Sunny, Please see the attached file
For the formula below I need the cell to be blank if the cell is blank or if the word void is in cell M4. =M4-J4 I figured it out to be thi...
This works =IF(OR(M2="",M2="void"),"",IF(M2-J2<=30,1,0)) What do I do for this one? =M4-J4 Thanks Rdawbrey
Hi Sunny, Thank you that does work, now my problem Once I put the formula in A1 I need A1 to stay blank if E2 is less than 366, another words ...