Microsoft Office Forums - View Single Post - [Solved] Need to calculate difference between 2 dates, sans W/E and holidays, with result in months and days

Thread: [Solved] Need to calculate difference between 2 dates, sans W/E and holidays, with result in months and days

View Single Post

Old

04-10-2025, 08:24 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

Code:

=INT(NETWORKDAYS(A1, B1)/30) & " months, " & MOD(NETWORKDAYS(A1, B1), 30) & " days"

Edit specific cells as required.

Reply With Quote