Formula for calculating MOST RECENT & OLDEST in Business Days

MeganJF ✭✭✭
edited 02/09/23 in Formulas and Functions

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")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!