Weeks left in year

[sheter]

I'd need help calculating the number of weeks left in the current year from "now".

 

[budda919]

=WEEKNUM(DATE(YEAR(TODAY()),12,31))-WEEKNUM(TODAY())


Although, you may want to exam how excel assigns the week numbers. For example, there are 53 weeks in some years.

 

[sheter]

this is exactly what i needed! Thank you Budda919! Perfect