calculating number of days
Need help trying to calculate number of days for my project so it will auto-update each time a row is added
The idea is to calculate the difference in days between, in this example Date row 2 and row 1 in a different column (days). I was able to get it to work utilizing =NETDAYS(Date2,Date@row) formula however when I try to convert to a column formula it returns a syntax error because, I believe I am looking up a specific cell. I need this to work in a column formula to allow subsequent updates to auto calculate difference in days. Any help would be appreciated.
Answers
-
Are you using a duration column in your sheet?
Ken Armstrong
Sr System Analyst, Carelon Medical Benefits Management
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
-
Ken,
Sorry for the delay in responding
No I am not utilizing duration because in this instance the goal is to calculate the difference between dates in subsequent rows. More specifically. the idea is to utilize a form to track the duration of when a fleet vehicle is placed out of service and , ideally reflect on a dashboard the duration that is took to get it back in service
Help Article Resources
Categories
Check out the Formula Handbook template!