"Peter" wrote:

When I apply this formula - =EOMNTH(E28,3) - to a date Jan-08 in cell E28
Excel gives me the correct answer Apr-08. When I use the same approach in an
IF statement it doesn't work. Here's the formula I'm using -
=IF(E28<=$B$78,E28,IF(E28-$B$78<6,EOMONTH(E28,3),E28))

$B$78 is TODAY - Oct-07

Can any body help

Thank you. I stupidly forgot the answer was in days. By changing the 6 to
180 I got the right answer.