Networkdays and If formula help
Hello! I could really use some help. I've reviewed previous Q&As and can't get my formula to work. I want to calculate net workdays based on a specific status selection and have it stop counting days once the status has changed. Status is in dropdown selection box.
I've automated the start date to populate when the "Waiting on Data" status is selected. What is a good formula to say, "count net workdays IF status is "Waiting on Data" and stop counting days when status is not "Waiting on Data"?
My latest formula attempt is unparseable.
=IF((Status@row, ='Waiting on Data'), NETWORKDAYS([Waiting on Data Start Date]@row, TODAY))
Thank you in advance for your help!!
Help Article Resources
Check out the Formula Handbook template!