Hi All,

I have recently moved from Excel 2003 to 2007, and noticed a problem with
one of my files. The formula is used to calculcate revenues on projects based
on the number of work days applicable in the month, and is as follows:

=IF($U6BD$2,0,IF($V6<BD$1,0,IF(AND($U6=BD$1,$V6 BD$2),SUM($AO6*(NETWORKDAYS($U6,BD$2)/NETWORKDAYS($U6,$V6))),IF(AND($U6<BD$1,$V6<=BD$2), SUM($AO6*(NETWORKDAYS(BD$1,$V6)/NETWORKDAYS($U6,$V6))),IF(AND($U6<BD$1,$V6BD$2),S UM($AO6*(NETWORKDAYS(BD$1,BD$2)/NETWORKDAYS($U6,$V6))),$AO6)))))

Whe
U6 = project start date;
V6 = project end date;
BD1 = month start date, and
BD2 = month end date.

The formula worked fine in 2003, and works in 2007 now that I have redone
it. The problem was that, when I opened the sheet this morning (in
compatability mode initially), all the formulas had been replaced with =#N/A.

Does anybody know why that happened, and how I can avoid it, or correct it
in future?

Thanks in advance,

Alan