Overdue calculation.

[lauraem]

Hello All,

I am trying to come up with a formula to calculate the days overdue since the target completion date.

Date raised and target completion have a formula for 30 days.


The red line is row 5.

Any help will be much appreciated.

 

[bebo021999]

Is it?

W5=V5+30

Y5=X5-W5

Or something else?

 

[BrerRabbit]

Have you tried a simple subtraction formula? =A4-A3. It will give you an answer of 12.

Try this formula to say how many days overdue or if the project was delivered on time:
IF(B13-C13<0,"" & B13-C13 & " days overdue","Project done on time")

 

[Fluff]

Hi & welcome to MrExcel.
If you only want to account for working days, maybe

=NETWORKDAYS(W5,X5)

 

[lauraem]

Hi & welcome to MrExcel.
If you only want to account for working days, maybe

=NETWORKDAYS(W5,X5)

Thank you that has worked!

The only issue now is the ones that aren't complete....is there anyway that they can count to the day? Or something?

 

[Fluff]

How about

=NETWORKDAYS(W5,if(X5<>"",X5,today()))

 

[lauraem]

How about

=NETWORKDAYS(W5,if(X5<>"",X5,today()))

Superb! thanks so much for your help!! So glad I found you!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[lauraem]

Glad we could help & thanks for the feedback.

Apologies, one more question....as I've used network days my trending and time that I am allowing for target completion is wrong.

Is there a way that my +30 days for target completion can be network days also?

 

[Fluff]

You would need to use WORKDAY for that.