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!!
=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!!