Good morning. I am trying to write a formula that will take into account the weekends and holidays, which I have done with Networkdays. Now I am trying to expand that formula to look at the actual dates and return a 0 if the creation and closure are the same day.
-- removed inline image ---
-- removed inline image ---
Column B2 - 5/1/15 12:04 AM
Column C2 - 5/1/15 3:12 PM
=Networkdays(B2,C2,Holiday_2015) is my current formula
When I use =Days360 (b2,c2) I get a value of 0
Can anyone assist me on how to get these 2 formulas combined to give the correct answer?
Thank you.
Candy Baldwin
-- removed inline image ---
-- removed inline image ---
Column B2 - 5/1/15 12:04 AM
Column C2 - 5/1/15 3:12 PM
=Networkdays(B2,C2,Holiday_2015) is my current formula
When I use =Days360 (b2,c2) I get a value of 0
Can anyone assist me on how to get these 2 formulas combined to give the correct answer?
Thank you.
Candy Baldwin
Last edited: