Hi Peter,

I hope you realize that that is a rather inaccurate solution :-)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Peter" wrote in message ...
|
|
| "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.
|