Number of weeks countdown from today to start date

Brittany Sanders

Hi!

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!!

Paul Newcome

Try something like this:

=(TODAY() - [Start Date]@row) / 7

Paul Newcome

Try flipping the first part around so that you are subtracting today from the start date.

Paul Newcome

Try something like this:

=(TODAY() - [Start Date]@row) / 7

Brittany Sanders

@Paul Newcome That came back with the correct number, but it was negative. How can I make it positive?

Paul Newcome

Try flipping the first part around so that you are subtracting today from the start date.

Brittany Sanders

That worked, thank you!!

Paul Newcome

Happy to help. 👍️