Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula to Calculate all screening dates in last 7 days and last 30 days.

Options
Darcie Wilson
Darcie Wilson ✭✭✭
edited 08/24/17 in Archived 2017 Posts

I am seeking a formula that will calculate all dates that occurred within the last 7 and 30 days...based on the "Screening Date" column...and should not include weekends if possible.

Thank you 

8-24-2017 4-10-01 PM.jpg

8-24-2017 4-10-01 PM.jpg

8-24-2017 4-10-01 PM.jpg

8-24-2017 4-10-01 PM.jpg

8-24-2017 4-10-01 PM.jpg

8-24-2017 4-10-01 PM.jpg

Tags:

Comments

This discussion has been closed.