Number of weeks countdown from today to start date



I've searched other threads and haven't found a formula that works for me. I'm trying to create a countdown in weeks for events on a sheet to pull into a dashboard. I want to display the number of weeks from today's date to the event start date.

I tried this formula: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Start Date]12) and since the Start Date was in 2024 it came back with negative number.

Thanks for you help!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!