My goal is to see how many days will be spent for a task in a project. I have Start date and End date. With these inputs, I want to be able to see no. of days excluding weekends.
What I am doing currently is doing a formula,
ToNumber(thisRow.End- thisRow.Start). However, this doesn’t exclude weekends
hi @Nat_Q , welcome!
in case your weekends are Sat & Sunday
in case team members have days off in between, you can treat them as holidays and coda will filter them out for you.
Have you tried using this formula with
Another way to proceed without this formula (much more complicated , but interesting to understand) would be to check for each date between start and due if this is a saturday (#6 or a #7), remove them, and count the remaining days (add
.Count() to Column 6 value)
Worked perfectly, thank you!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.