Calculate number of days between two dates in the same column on the same sheet

Hello,

Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column?

I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types.

For Example: Studio Name is equal to Studio Name on a different row (Same Sheet) and has a different project type (Project A / Project B). Then calculate the number of days between the start date of the two rows (Start date #1 - 10/20/25 | Start date #2 - 10/30/25). It shows the net days between the two rows in a helper column.

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

All comments

There are no accepted answers yet

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