Calculating duration using "Actual Start Date" and Todays date
Hi, I am trying to calculate duration and I have tried every formula I can google leaving me with unparseable or incorrect argument set... the fields I am trying to use in my metric sheet are "Actual Start Date" and then TODAYS date. I currently have several variations of this =IF(TODAY() - [Actual Start Date]@row)) or =IF(ISDATE(TODAY()) - [Actual Start Date]@row.
Any help is greatly appreciated, TY!
Best Answer
-
A few different ways you can do this.
Omits non-work days based on your project settings =NETWORKDAY([Actual Start Date]@row, TODAY())
Omits non-work days based on your project settings=NETWORKDAYS([Actual Start Date]@row, TODAY())
Number of calendar days between days, including today =NETDAYS([Actual Start Date]@row, TODAY())
Number of calendar days between days, excluding today =TODAY() - [Actual Start Date]@row
I forget what the difference between NETWORKDAYS and NETWORKDAY actually is, I think one of them doesn't include the start/end date. But play with all of them and see which one works for you.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Answers
-
A few different ways you can do this.
Omits non-work days based on your project settings =NETWORKDAY([Actual Start Date]@row, TODAY())
Omits non-work days based on your project settings=NETWORKDAYS([Actual Start Date]@row, TODAY())
Number of calendar days between days, including today =NETDAYS([Actual Start Date]@row, TODAY())
Number of calendar days between days, excluding today =TODAY() - [Actual Start Date]@row
I forget what the difference between NETWORKDAYS and NETWORKDAY actually is, I think one of them doesn't include the start/end date. But play with all of them and see which one works for you.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thank you the =TODAY() - [Actual Start Date]@row worked!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!