Weeks remaining of current quarter

[Godders199]

Hello, I am looking for a formula that will tell me the number of weeks left in the current quarter, is anyone able to help me

Thank you.

 

[Joe4]

We can use the formula found here to calculate the date that ends the current quarter: https://www.extendoffice.com/documents/excel/4019-excel-calculate-quarter-start-date-end-date.html
Then, we just subtract the current date and divide by 7, like this:

=(DATE(YEAR(TODAY()),((INT((MONTH(TODAY())-1)/3)+1)*3)+1,1)-1-TODAY())/7

 

[Godders199]

Thanks for your help

 

[Joe4]

You are welcome.