Not necessarily, 180 days is approximate for instance 180 days added to Jul
1 07 will return 12/28/07

with 07/01/07 in A1

=A1+180

returns 12/28/07

whereas

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

returns 01/01/08



--


Regards,


Peo Sjoblom



"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.