Hi Community & Formula Experts,
I’m trying to set up a formula in monday.com to calculate leave days based on a Timeline column.
Requirement:
-
Leave dates are submitted via a form into a Timeline column named “Leave Start Date/End Date”
-
The formula should calculate working days only
-
Example:
If someone applies for leave from 1st Feb to 10th Feb, the result should be 7 working days -
The formula should exclude weekends and return only the actual leave days
Issue:
- My current formula is not calculating the exact working days correctly.
Can someone please help me with the correct formula to achieve this?
Thanks in advance for your support!
The current formula is suggested by AI
MAX(
0.5,
IF(WEEKDAY({Leave Start Date/End Date#Start},2)=5, 0.5, 1)
IF(AND({Leave Start Date/End Date#End} <> {Leave Start Date/End Date#Start}, WEEKDAY({Leave Start Date/End Date#End},2) <> 6, WEEKDAY({Leave Start Date/End Date#End},2) <> 7),
IF(WEEKDAY({Leave Start Date/End Date#End},2)=5,0.5,1),
0
)
MAX(0, WORKDAYS({Leave Start Date/End Date#Start},{Leave Start Date/End Date#End}) - 2)
)
