Date formula using Today
Options
Hi,
I want a formula to show how long a project has been running.
For example, I want:
Today - the start date = X number of business days.
8/5/21 - 7/20/21 = 12 business days
How do I write a formula for this in Smartsheet?
Thank you!
Best Answer
-
Don't put anything in the parenthesis for the TODAY function. Leave it exactly as is
TODAY()
=NETWORKDAYS([Project Start Date]@row, TODAY())
Answers
-
You would want a NETWORKDAYS function.
=NETWORKDAYS([Start Date]@row, TODAY())
-
Hi,
That did not work. It says #UNPARSEABLE
=NETWORKDAYS([Project Start Date]@row, TODAY(08/05/2021))
is what I attempted.
-
Don't put anything in the parenthesis for the TODAY function. Leave it exactly as is
TODAY()
=NETWORKDAYS([Project Start Date]@row, TODAY())
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!