# Displaying a date only if the month is an even number

1. ## Displaying a date only if the month is an even number

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,"")

2. ## Re: Displaying a date only if the month is an even number

Take a look at seeing if you can modify this to your use?
=iseven(MONTH(cell-ref))

3. ## Re: Displaying a date only if the month is an even number

Thank you FDibbins, I added that formula to another cell, moved my original to F12 (and hid both of those cells) and used =IF((E12=TRUE),F12,"") in the cell I wanted the value in. So glad to finally have this working, thanks again for your help.

4. ## Re: Displaying a date only if the month is an even number

Great stuff and thanks for the feedback and kind words

You could have also used
=IF(E12,F12,"")

Also, maybe put the whole thing in 1 cell?
=if(formula-in-E12,F12,"")

There are currently 1 users browsing this thread. (0 members and 1 guests)