Elapsed Days Counter - How?

Hi everyone,

I'm needing to report on elapsed days for a few tasks. Anyone know how to do this?

Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet.

Any help is greatly appreciated!

Thanks

Find more posts tagged with

Formulas

Reports

Gantt View

Project Management

Enhancement Request

Comments

StacyDe

Heres an example of how to see "how many days has it been since the start of this task"... if the start date is in row 3:

=SUM(TODAY() - [Start Date]3)

darelcragnolin32946

If you only want to count working days, you can also use the NETWORKDAYS function, taking the difference between your start date and a TODAY reference. This function can also reference specific holidays so that they aren't counted.

bdchapin

Something like this?

=NETWORKDAY(Start1, IF(ISBLANK(Finish1), TODAY(), Finish1))

This will count the workdays between start and finish and use today's date if the task has not completed.

J McMahon

Hello StacyDe,

Thank you for your comment. I am trying to do the same thing, and I keep coming up with at error (#DATE EXPECTED) when I use your formula. Any clue as to what I'm doing wrong?

Thanks,

John

Katye Reed

Thank you, I found this formula to be extremely helpful as another way to track at risk tasks and trigger a prioritization review by the appropriate personnel.

topazfae

@Needing some Help

I know this is old post - but to answer your question - you can do this following formula (they added new formula ot make it easier).

Reason why you got the error - #Date expected because you set the column to date. You need to change it to text/number. They expect the result to be date but the result came out as a number which conflict with the column's type.

What I did was

=SUM([End Date]@row - [Start Date]@row)

It gives me the number of days lapsed - Start date is on May 11, 23 and the end date is May 14, 23, it will give me 3.

Sign in to join the conversation!

Quick Links

Trending discussions

Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.
Original sheet is corrupted or has some hidden issue preventing the formula from working?
I have a sheet where a formula in one column is not being applied . However, when I save the sheet as new, the formula works as expected. Is it possible that the original sheet is corrupted or has some hidden issue preventing the formula from working?