Help with a formula : need one for duration since received ?
Hello :) looking for a formula to give me the days since received from planner . only counting working days M-F. Thank you
Best Answer
-
I'm glad this worked for you.
The following formula checks the cell [Completed Date]@row for a blank, if it's blank it will preform the formula, if it's not blank then it will populate "Completed". Replace the word [Completed Date] with the name of your completed column.
=IF([Completed Date]@row="",NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY())),"Completed")
You can replace the word at the very end in quotes "Completed" with whatever you want it to say or make it blank with ""
Answers
-
Hello @BCALLEN
Let me know if this formula works for you:
=NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY()))
-
yes that works thank you SO SO MUCH!! is there a way for it to STOP counting when the COMPLETED DATE is entered ? @Mr. Chris
-
I'm glad this worked for you.
The following formula checks the cell [Completed Date]@row for a blank, if it's blank it will preform the formula, if it's not blank then it will populate "Completed". Replace the word [Completed Date] with the name of your completed column.
=IF([Completed Date]@row="",NETWORKDAYS([DATE RECIVED FROM PLANNER]@row, (TODAY())),"Completed")
You can replace the word at the very end in quotes "Completed" with whatever you want it to say or make it blank with ""
-
THATS PEWRFECT !! THANK YOU @MrChris
-
My pleasure! Thanks for the feedback.
Help Article Resources
Categories
Check out the Formula Handbook template!