Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Difference in Days between Projected & Actual Start Dates/ End Dates?

Options
edited 12/09/19

My managers want a column that calculates number of work days (Mon. - Fri) between Projected Start Date and Actual Start Date. Example: Projected Start Date (in Column A): 09/01/16. Actual Start Date (in Column C): 09/09/16. Difference in Days between projected and actual start dates (Column : 6 Days.

What formula would I use in Column B to get the number of work days between Projected and Actual Start dates?

(This calculation might also be useful to calculate difference in work days between stated "Need By" date and actual completion date in another column).

Thanks!

Tags:

• Options

I found the answer to my question in the Help Center, it was basically this, the NETWORKDAYS formula... and yes, it works!

NETWORKDAYS()

Returns the number of working days between a start date and end date.

Syntax: NETWORKDAYS(start, end, <holiday_range>)

Arguments:

• start - Required. The start date
• end - Required. The end date.
• holiday_range - Optional. The dates to exclude from the count (for example, holidays or other specific dates).

Examples:

=NETWORKDAYS([Due Date]4, [Due Date]5)
Result: 20

=NETWORKDAYS([Due Date]1, [Due Date]5, [Due Date]2:[Due Date]3)
Result: 85

NOTE: By default, the WORKDAYS, NETWORKDAY, and NETWORKDAYS formulas count Saturday and Sunday as non-working days. If dependencies are enabled on your sheet you can customize the non-working days, and the formulas will use your settings in calculations.

This discussion has been closed.