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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…