I am developing a Project Tracking Workbook and need to calculate the difference between START DATE (Col N) and END DATE (Col P) as the TOTAL PRODUCTION TIME (Col R) in months and days.



I have tried two formulas, as follows:

=IF($N10<>"",IFERROR(DATEDIF($N10,$P10,"ym")&" months "&DATEDIF($N10,$P10,"md")+1&" days", "No 'End Date' Entered"),"")

This one works, but does not remove W/Es or holidays. It is in cells R4 and R5 of the attached screenshot.

=IF($N12<>"",IFERROR(NETWORKDAYS($N12,$P12,M116:M1 23)&" months "&NETWORKDAYS($N12,$P12,M116:M123)&" days", "No 'End Date' Entered"),"")

This is my poor attempt to incorporate NETWORKDAYS, which kind of works but returns only the number of days in both counts. It is in cell R6 of the attached screenshot.

I have tried several methods to convert the (first) calculation result into months with no luck.

Any suggestions?

Attached Images

screenshot.jpg (77.6 KB, 13 views)

Edit specific cells as required.

Logit,

OMG! That is PERFECT. A simple, elegant solution to chaos I lost myself in chasing through my inexperience in Excel.

THANK YOU VERY MUCH for throwing this lifeline.

You are welcome.

Let's assume the start date is 28.02.2025, and the end date is 29.03.2025. Is the time interval 0 months and 29 days, or 1 month and 1 day?

When you want approximate number of months and days, the Logit's solution is OK!