Formula for calculating today minus the case created date

Hi,

I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date?

=TODAY()-C2

I'm trying to show the actual case age without including the weekends and holidays.

Thank you in advance for the one who will answer.

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

Ray Lindstrom

Hi @Czarmaine Quemuel,

Try this:

=NETWORKDAYS(C2, TODAY())

This will exclude weekends as well as any holidays you have defined in your Project Settings. Remember you can access your Project Settings by right-clicking a column header, and selecting "Edit Project Settings". Dependencies must be enabled there first, and then you can select which days of the week are in-scope as well as exclude holidays (dates) by listing them, comma-separated, in the space provided.

Hope this helps!

BRgds,

-Ray

Ray Lindstrom

Hi @Czarmaine Quemuel,

Is your C2 date in the future?? If so, that's what is causing it.

If not, here are a couple things to try:

=ABS(NETWORKDAYS(C2, TODAY()))

=NETWORKDAYS(TODAY(), C2)

All comments

Ray Lindstrom

Hi @Czarmaine Quemuel,

Try this:

=NETWORKDAYS(C2, TODAY())

Hope this helps!

BRgds,

-Ray

Czarmaine Quemuel

Hi @ray

Wow, Yes, I tried it but it showing as a negative number. How can I fix that?

Ray Lindstrom

Hi @Czarmaine Quemuel,

Is your C2 date in the future?? If so, that's what is causing it.

If not, here are a couple things to try:

=ABS(NETWORKDAYS(C2, TODAY()))

=NETWORKDAYS(TODAY(), C2)

Czarmaine Quemuel

Hi @Ray Lindstrom ,

This has been helpful.

Thank you so much!

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.