T-minus dates when going over to next year

Hi. We utilize a t-minus template and it works great until I move where the launch date is in next year and today's date is in this year.

=WEEKNUMBER([T-Minus Date]2) - WEEKNUMBER([T-Minus Date]3) + ""

I've tried manipulating the basic formula but to no avail. Probably a rather simple change, but I'm stumped.

A manual calc of weeks is 30 from the picture attached. But the formula comes back with 23.


Help a guy out?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!