This one's been frying my head. I have a formula that displays a value from a cell (D12) if a date in a different cell (C12)falls before a date from a third cell (F2). That's the easy bit, what I want to do is to have the cell only display the value if the month in the second cell is an even number and to be blank if its an odd one. Is this possible and if so how? Thank in advance for any help, the formula I'm currently using is;
=IF(C12<=F2,D12,"")
Bookmarks