Calculate Variance in Days

I need to create a formula that calculates the total number of days an employee is in training.

One cell in my sheet is the Training Start Date.

One cell in my sheet is Today's Date

I need this cell to calculate the number of days between these to days.

I tried

=NETDAYS(start_date, end_date) and it give me #UNPARSEABLE

Find more posts tagged with

Accepted answers

All comments

Hi @Darcy Herold

Try this instead:

=NETDAYS([Start Date Column]@row, [End Date Column]@row)

Hope it helped!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.