how to calculate difference in days between two dates that also contain time AND exlcuding weekends

[skim22]

Hi all, I have two cells which contains the date & time stamp in the following format: "mm/dd/yyyy hh:mm" - A2 contains the "create date" and B2 contains the "review date". What I want to do is see how many days have elapsed between the create & review date. I found a formula which neatly shows how many days, hours, and minutes have elapsed but this formula does not exclude weekends. The formula is below:

=INT(B2-A2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&" Minutes"

example returns "42 Days 4 Hour 36 Minutes"

Can this formula be edited to exclude weekends and still return the answer in the same format? Please help and thank you!!

 

[JLGWhiz]

=NETWORKDAYS(B2, A2,2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&" Minutes"

This uses the NETWORKDAYS() function which uses (EndDate, StartDate, holidays) for arguments. So if you were checking from 1 January to present), there would be 2 holidays for the third argument as shown in the formula above.

 

[skim22]

=NETWORKDAYS(B2, A2,2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&" Minutes"

This uses the NETWORKDAYS() function which uses (EndDate, StartDate, holidays) for arguments. So if you were checking from 1 January to present), there would be 2 holidays for the third argument as shown in the formula above.

Thank you!

 

[JLGWhiz]

Thank you!

You're welcome,
Regards, JLG