Calculate time between start date and today's date

HarryS

Hello,

Having trouble with creating a formula. I would like to calculate the number of days between the following two columns:

Created Date & Today's Date

I have a third column called Days Open where I would like the calculation to automatically generate each day.

Can anyone provide me with a formula that would work for my use case?

Find more posts tagged with

Accepted answers

All comments

JYokoi

@HarryS
=NETDAYS([Created Date]@row, TODAY())
and make it a column formula.

HarryS

Thanks! Are the weekend days not included when using this formula?

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.