calculating duration planned Days, Elapsed Days, Remaining and Overrun days

[Abby93]

Greetings
I'm trying to manage a project by calculating its duration in Excel and trying to define( planned Days, Elapsed Days, Remaining and Overrun days automatically with taking into consideration international Calendar and holidays,
Thank you & much appreciated


Hence: in Elapsed Day formula bar, i couldn't add NETWORKDAYS.INTL and the holidays (an error message appears and shows so many arguments is invalid)

 

[Abby93]

Try it like

=IF(ISBLANK(A5),"",IF(OR(ISBLANK(C5),ISBLANK(D5)),0,IF(OR(Today>D5,NOT(ISBLANK(E5))),0,IF(Today<C5,NETWORKDAYS.INTL(C5,D5,7,NK22:NK43),NETWORKDAYS.INTL(TODAY(),D5,7,NK22:NK43)))))

it worked perfectly
than you
but the Overrun didn't work at well,
previously it wads worked

this is the formula
=IF(ISBLANK(A5),"",IF(NOT(ISBLANK(E5)),IF(E5>D5,E5-D5,0),0))

 

[Fluff]

In what way doesn't it work?
Neither of the formulas should affect that formula.

 

[Abby93]

it worked finally, so far so good,
thank you so much I'll try to finish the task and if have any question I'll post it many many thanks

 

[Fluff]

Glad to help & thanks for the feedback.