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.
Best Answer
-
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
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!