Thread: #Name? message

Good evening everyone:

I have the following formulas that are in a spreadsheet I downloaded from the web. It won't calculate the working days, days completed, and days remaining within the their cells using start and finish dates. It returns #Name? error message (the formula contains unrecognize text)

for working days it is

=IF(AND(G16<>"",H16<>""),IF($E$8=1,NETWORKDAYS(G16,H16),IF($E$8=3,H16-G16+1,NETWORKDAYS(G16,H16)+SUM(OFFSET($L$15,-2,MATCH(G16,$L$15:$IA$15,0)):OFFSET($L$15,-2,MATCH(H16,$L$15:$IA$15,0)-1)))),"")

for days completed it is

=IF(AND(G16<>"",H16<>""),IF($E$8=1,NETWORKDAYS(G16,TODAY())-1,IF($E$8=3,TODAY()-G16,IF(AND(WEEKDAY(G16,2)<7,WEEKDAY(TODAY(),2)=7),NETWORKDAYS(G16,TODAY())+1,IF(OR(WEEKDAY(G16,2)<7, WEEKDAY(TODAY(),2)=7),NETWORKDAYS(G16,TODAY()),NETWORKDAYS(G16,TODAY()))))),"")

for days remaining it is

=IF(AND(G16<>"",H16<>""),I16-J16,"")

I am not an excel expert and this would help tremedously in a project
Please help, what can be wrong? Thank you very much.

Thank you daddylonglegs. Both were my thoughts - a simpler formula or use the toolpak. I will let you know what happens. Thanks again and have a great day!