Subtract between two dates in a row only counting weekdays, and drag formula down rows

Can anyone help me to subtract between two dates in a row only counting work days, and drag the formula down rows?

Thanks!

attached is an exampleFloor Deadline Performance Chart 6.19.13.xlsx

I assume you are filling out Column H.

Try:

Please Login or Register  to view this content.

. It will check to make sure that there is a number in cell F2, and then if it is true, it will give the date between the complete and the Date Sent to Floor. Otherwise, it will say "Incomplete" for jobs that do not yet have a complete date.

Also, you may need to make sure you format the cells properly. If you are getting errors or incorrect answers, format them as "Number".

Thank you so much for helping Pynergee!

Do you know if that formula can be adjusted so that it states "incomplete" if a due date is listed (column [E]), however, remaining blank if no information is in column [E]?

Please Login or Register  to view this content.

That should work. It will only go to column E if the complete date hasn't been filled in, otherwise it will list the difference in days.

This works Great! I'm very happy with this! However, do you know how to adjust the formula so that only weekdays are included?

That I'm not too sure of... I can't see any usage of the Workday formula, but the only way you may be able to do it is to include the WEEKDAY formula and also a few IF statements for if the WEEKDAY formula outputs a 1 or a 7, for sunday or saturday. I can't be 100% though. Perhaps someone else would be more helpful with that.

Alright, I'll mark this as solve and repost with a more specific question asking for modification to your given formula. Thanks!!

Thanks Kevin,

I looked into it a bit, but I am unsure of how to integrate it into my current formula.

=IF(ISNUMBER(F2),F2-D2,IF(ISNUMBER(E2),"Incomplete"," "))

Daddylonglegs,

When I tried your formula, the output generated was 29597
29598
29604
29603
29604
29608
29624
29601
29595
29597... etc. Here is my work book.

=IF(ISNUMBER(G2),G2-E2+1,IF(ISNUMBER(F2),"INCOMPLETE"," ")) has solved it! Thanks!

Also,

I have gotten your formula to work!

=IF(ISNUMBER(G2),NETWORKDAYS(E2,G2),IF(ISNUMBER(F2),"Incomplete",""))

with F2 as Due Date, E2 as Start Date, and G2 as date completed!

Thanks!

Thanks