Date formula using Today

Katie Aldrich

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!

Paul Newcome

Don't put anything in the parenthesis for the TODAY function. Leave it exactly as is

TODAY()

=NETWORKDAYS([Project Start Date]@row, TODAY())

Paul Newcome

You would want a NETWORKDAYS function.

=NETWORKDAYS([Start Date]@row, TODAY())

Katie Aldrich

Hi,

That did not work. It says #UNPARSEABLE

=NETWORKDAYS([Project Start Date]@row, TODAY(08/05/2021))

is what I attempted.

Paul Newcome

Don't put anything in the parenthesis for the TODAY function. Leave it exactly as is

TODAY()

=NETWORKDAYS([Project Start Date]@row, TODAY())