Number of weeks past in current qtr

  • Thread starter Thread starter AD108
  • Start date Start date
A

AD108

Hello,

I need to write a formula that returns the number of weeks already past, in
the current quarter. The value returned should include a partial week if
today is the middle of the week. (sunday is the start of a week)

Any help would be appreciated. I know I am being lazy, but I can't stay
awake any longer.

Thanks.
 
=WEEKNUM(TODAY())-WEEKNUM(DATE(YEAR(TODAY()),INT((MONTH(TODAY())+2)/3)*3-2,1))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to tell day of week 2
Finding the date using the number of the week in a year 2
Week No Q 3
Convert Week number to Month 0
Rolling 12 week calculations 2
Finding the next dayof the week after a certain date. 4
Calculate difference between current date & prior 3
If cell = now – current Qtr – 28 days then RED 3

Back
Top