Number of weeks past in current qtr

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.
 
B

Bob Phillips

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top