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:
If you have an idea of the formula to use? thanks
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))))