Aging Reports - Calculating Entries open more than 15 days

Director Dan

I have a sheet that collects a significant amount of data from Update Request workflows, and I am trying to develop a metric that shows all entries that have aged more than 15 days. I have a Date the entry is initiated and a date the entry was closed, but I'm having a hard time trying to figure out to extract that into a count of those items still open more than 15 days after being initiated.

Any advice would be appreciated!

SmartWay360

Hi,

You can use NETWORKDAYS formula if you want to calculate only working days:

IF(NETWORKDAYS([Date of entry]@row, [Date of closure]@row)>15, "Older than 15 days", "Not older than 15 days")

More on NETWORKDAYS: NETWORKDAYS Function | Smartsheet Learning Center

If you want to include weekends to your day count you can use formula: NETDAYS.

Best,

Beata