Smarstheet formula

Yakshita Srivastava

How can I use this highlighted formula. Appreciate quick response

Paul Newcome

To get the duration you can either use

=[End Date]@row - [Start Date]@row

to get the total number of days,

or you can use

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

to get the number of working days.

Paul Newcome

Are you wanting to edit the formula, or use the output in another formula, or something else?

Yakshita Srivastava

I am trying to use date formula, I have start date , end date. Want to reflect the gap between two in Duration column

Andrée Starå

Hi @Yakshita Srivastava

I hope you're well and safe!

If you right-click on a cell you can select something like Edit Column Formula to see the formula.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dale Murphy

@Yakshita Srivastava You said:

"... I am trying to use date formula, I have start date , end date. Want to reflect the gap between two in Duration column ..."

You know that SmartSheet does that for you, right? If you activate a Gantt chart and dependencies, a column called Duration will be used for that purpose. No programming necessary on your part.

dm

Paul Newcome

To get the duration you can either use

=[End Date]@row - [Start Date]@row

to get the total number of days,

or you can use

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

to get the number of working days.