Number of weeks past in current qtr
 

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.

--
Remove 7 numbers to email
AD108

Number of weeks past in current qtr
 

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"AD108" wrote in message
...
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.

--
Remove 7 numbers to email
AD108

Number of weeks past in current qtr
 

Thanks alot Bob,

I'll study this one and figure it out.

Ariel

"Bob Phillips" wrote in message
...

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"AD108" wrote in message
...
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.

--
Remove 7 numbers to email
AD108