Counting only weekdays Formula?
Hello,
I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current to capture the amount of days it has been open. Also while I need it to count the amount of days its been open i need it to stop counting if the date closed is there.
Formula; =IF(Status@row = "Closed", [Date Closed]@row - [Date Opened]@row, TODAY() - [Date Opened]@row)
Answers
-
I think you will need to use NETWORKDAYS in your formula.
-
Hi Maybe I am not understanding the NETWORKDAYS formula but while i understand the formula as a whole how do i make it so its every weekend. I see that i can put holidays but do i have to list every weekend? Tickets can be places when every so how would i have it exclude every weekend?
Help Article Resources
Categories
Check out the Formula Handbook template!