0

For an Item in my list I have three columns, "date started", "date completed", and "# of business days to complete"

Is there a way to build a flow so that when "date completed" is modified it calculates the number of business days between the two dates (including holidays) and auto fills the "# of business days to complete" column?

I have a list that stores the holidays for reference.

Improve this question

1 Answer 1

Reset to default
1

According to your needs, I suggest that you can create a Calculated column to achieve your needs.

Please follow the steps:

1.Go to the list, click List settings

enter image description here

2.On the List Settings page, under the Columns section, click "Create column" to create a Calculated column named [# of business days to complete]

enter image description here

3.Please use the below the Formula:

=IF(ISBLANK([Date Completed]),"",([Date Completed]-[Date Started]))

enter image description here

4.Here is my test:

enter image description here

Improve this answer
6
  • thank you, I have tried this and this doesnt take into account holidays though. From my understanding the only way I can do that is using flow and referring to my other holiday list somehow.
    – FatZack
    Commented Dec 14, 2021 at 14:10
  • Hi FatZack. According to my understanding, you want to calculate the number of working days between [Date Started] and [Date Completed], and you want to exclude holidays. Can you upload screenshots of the Holiday list? This will help us solve the problem better.
    – EchoDu_MSFT
    Commented Dec 15, 2021 at 9:57
  • just uploaded it.
    – FatZack
    Commented Dec 15, 2021 at 17:40
  • Hi FatZack. Sorry, I still can’t see any information you uploaded here (including screenshots)
    – EchoDu_MSFT
    Commented Dec 20, 2021 at 6:17
  • for some reason it was deleted by admin, but it is a simple list with two columns. One is the Holiday date and one is the Holidays name.
    – FatZack
    Commented Dec 20, 2021 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.