Numbers of days per month from a timeline

Platform discussions Special workflows & use cases
1

Hello, From a timeline i would like to calculate the number of days per month present in the timeline. Exemple of what i would like to achieve:
image
If you have an idea of the formula to use? thanks

2

I succeed doing it! Exemple of formulas for July
IF(

AND(DATEVALUE({Échéance Pose#Start})<DATEVALUE(“07/01/2023”), AND((DATEVALUE({Échéance Pose#End})>=DATEVALUE(“07/01/2023”))), DATEVALUE({Échéance Pose#End})<DATEVALUE(“08/01/2023”)), WORKDAYS({Échéance Pose#End},“07/01/2023”),

IF(

AND(DATEVALUE({Échéance Pose#Start})>=DATEVALUE(“07/01/2023”),(DATEVALUE({Échéance Pose#End})<DATEVALUE(“08/01/2023”))),

IF(DAYS({Échéance Pose#End},{Échéance Pose#Start})+1 > 5 , WORKDAYS({Échéance Pose#End},{Échéance Pose#Start}), DAYS({Échéance Pose#End},{Échéance Pose#Start})+1),

IF(

AND(DATEVALUE({Échéance Pose#End})>=DATEVALUE(“08/01/2023”), AND((DATEVALUE({Échéance Pose#Start})>=DATEVALUE(“07/01/2023”))), DATEVALUE({Échéance Pose#Start})<DATEVALUE(“08/01/2023”)), WORKDAYS(“07/31/2023”, {Échéance Pose#Start}),

IF(

AND(DATEVALUE({Échéance Pose#Start})<DATEVALUE(“07/01/2023”),(DATEVALUE({Échéance Pose#End})>=DATEVALUE(“08/01/2023”))), WORKDAYS(“07/31/2023”,“07/01/2023”), 0))))