Automatic Duration column calculation + Linked Dates, is this possible?

Is it possible to have a "Duration" column that automatically calculates duration days based on End Dates that are linked to another sheet?

For context these are my 2 scenarios:

One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.

Two: My Start Dates are linked to another sheet, my End Dates are linked to another sheet, BUT now my Duration column stops automatically calculating my total days.

Find more posts tagged with

hyperlink

Accepted answers

Genevieve P.

Hi @Cesar Fernandez

You can use a formula in a regular text/number column instead of using the Project sheet's automatic duration.

You can use NETWORKDAYS to find out the number of working days between two dates, like so:

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

See: NETWORKDAYS Function

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Cesar Fernandez

You can use a formula in a regular text/number column instead of using the Project sheet's automatic duration.

You can use NETWORKDAYS to find out the number of working days between two dates, like so:

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

See: NETWORKDAYS Function

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.