Formula for calculating MOST RECENT & OLDEST in Business Days

MeganJF

Part 1)

How old is the most recent request? I have done this one before, but cannot remember what I am missing.

=MAX([Date Submitted]:[Date Submitted])

Part 2)

I have the formula, but want it to calculate in business days. I'm sure this is something simple I am overlooking.

=TODAY() - MAX(COLLECT([Date Submitted]:[Date Submitted], Status:Status, OR(@cell <> "New Request", @cell <> "Reviewing Request")))

Paul Newcome

Are you trying to calculate the number of days for #1?

For #2: Try a NETWORKDAYS function.

=NETWORKDAYS(start_date, end_date)

MeganJF

For part 1, Want to calculate how old the most recent request is.

Paul Newcome

In that case you would use the same NETWORKDAYS function as in #2.