Starting today, Sunday, May 12, 2024, we have 33 weeks or 233 days remaining. We are currently in week number 20 of the year.
To calculate how many weeks are left in the current year, you can use the following steps:
1. Get the current week number.
Today, Sunday, May 12, 2024, we are in week 20 of the year.
2. Determine the total number of weeks in the current year.
In 2024 there are 52 weeks.
3. Subtract current week number from the total number of weeks .
52 - 20 = 33 weeks.4. The result is the number of weeks remaining.
33 weeks left in 2024.
To compute the number of weeks remaining in the year from the current date in Excel or Google Sheets, use the following function in a cell:
=INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7)Alternatively you can use the formula that rounds the number.
=ROUND((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7, 0)