Difference between Today & 7 Days Ago

Donni Matthew
Donni Matthew ✭✭✭✭
edited 07/19/22 in Formulas and Functions

We have a sheet that contains dates in the column headers with a # of widgets in the cells by office. We are wondering if there is a way to create a formula that would always compare the value for Today compared to the value from 7 days ago.

I've attached what our sheet looks like to help understand what we're trying to accomplish. As an example, in the ILD row we would like to show the difference between today (4/22/22 in our example) and & days prior (4/15/22). The result would be 5.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!