Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SU M((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13), "",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)) )),F12)

"RFJ" wrote:

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" wrote in message
...
=IF((O12=12/31/2005),(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),X1,FALSE)))*(360))*(F13) ),"",(SUM(((F32)/(DAYS360(DATE(2004,12,31),X1,FALSE)))*(360))*(F13) ))),F12)

The first part of the formula, (O12=12/31/2005), returns false even if
it's
true. The rest of the formula works great.

Any suggestions?