Heya, I am building the Vacation Tracker board and trying to count amount of days. so now I have 1 column as Timeline type and another as formula WORKDAYS({Vacation Days#End}, {Vacation Days#Start}), which helps me to count days.
In agency we have ability to take half day so I am wondering how to enhance formula so that if Status is “half day” then formula counts it as 0.5 day, not 1
Hey @nastya.kiana,
Just to clarify, are you currently using a status column to identify whether the employee is taking a full or half day off? If this is the case, I am thinking we can integrate the IF function with that status column. Let me know and we can move forward with testing this 