IF-DATE NESTED FUNCTIONS

[Kris138]

HELP!!! I am currently working on a project in which my boss wants me to calcuate the difference between two dates. I was able to calculate the difference of dates using the Networkingdays, also using the >=0 for everything that was positive and hid those 0 numbers. Everything negative he wants to see. My dilemma is we have another column in-between those two dates that needs to be re-calculated into if the "target date" is changed. Therefore, I can't find a formula that will automatically change and pick up that middle column.

Any help??

 

[Aladin Akyurek]

I was going to try it this way, but does anyone know how to do it w/o the networkingdays? I don't currently have that add-in installed.

THANKS!

=SUMPRODUCT(--ISNUMBER(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"&B1))),{1,2,3,4,5},0)))-1

would be equivalent to:

=NETWORKDAYS(A1,B1)

 

[PaddyD]

"I don't currently have that add-in installed"

tools | addins |analysis tool pack

 

[Kris138]

I currently don't have the capabilities of using a "networkingdays" add-in. But, I was able to use this formula

=IF(BY>A7,(C7-B7),IF(C7>A7,(C7-A7)," ")), BUT I am still trying to figure out how to calculate out the postive numbers in the networking day column. we don't want those to show.

any suggestions on that?

 

[texasalynn]

That function is from the analysis pack, which is what PaddyD was showing you how to add-in. This comes with the Excel software but isn't automatically added. If you add this you will have many useful functions.

HTH
texasalynn