0

Is there formula for calculated column to track days since ticket was created in SharePoint list? Only counts business days/. This is my formula =TODAY()-Created but its counting all days. Also is there way stop the counting once status of ticket is complete?

6
  • What is your formula?? Edit your question and post it.
    – teylyn
    Aug 24, 2021 at 20:51
  • @teylyn formula is =TODAY()-Created i apologize. Thanks
    – kidus
    Aug 24, 2021 at 20:51
  • Have you even tried to search? There are so many results from a google search. one of them here sharepoint.stackexchange.com/questions/197827/…
    – teylyn
    Aug 24, 2021 at 20:54
  • @teylyn yes i have tried to search this sir
    – kidus
    Aug 24, 2021 at 20:55
  • @teylyn those are for start to end calculation what i want doesn't have a end its just tracks the days since opened.
    – kidus
    Aug 24, 2021 at 20:56

1 Answer 1

1

Please following steps:

1.Create a Calculated Column named "Today" Formula:

=TODAY()

enter image description here

2.Create another Calculated Column named "WorkDays"

Formula:

=IF(ISERROR(DATEDIF([Created],[Today],"d")),"",(DATEDIF([Created],[Today],"d"))+1-INT(DATEDIF([Created],[Today],"d")/7)*2-IF((WEEKDAY([Today])-WEEKDAY([Created]))<0,2,0)-IF(OR(AND(WEEKDAY([Today])=7,WEEKDAY([Created])=7),AND(WEEKDAY([Today])=1,WEEKDAY([Created])=1)),1,0)-IF(AND(WEEKDAY([Created])=1,(WEEKDAY([Today])-WEEKDAY([Created]))>0),1.0)-IF(AND(NOT(WEEKDAY([Created])=7),WEEKDAY([Today])=7),1,0))

enter image description here

enter image description here

2
  • works great Thank you!
    – kidus
    Aug 25, 2021 at 20:52
  • Hi kidus. I'm glad to hear that your problem has been solved. If the answer is helpful to you, you can accept it as answer. The behavior will help others who meet the similar issue in the future quickly find the correct answer. Aug 26, 2021 at 3:15

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