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

Cesar Fernandez

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.

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

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