Formula for calculating today minus the case created date

Czarmaine Quemuel

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.

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)

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

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!