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.

Find more posts tagged with

Accepted answers

All comments

Ken Armstrong

Are you using a duration column in your sheet?

Nick Caputo

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.