Weeknum

I

itty

Is it possible to derive a formula to use as the excel built in function
"WEEKNUM"
Thanks,
Itty
 
B

Bob Phillips

Do you mean not using the ATP?

=1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/
7)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Arvi Laanemets

Hi

It is. Even more, when you want to get ISO-compatible weeknumber, this is
the only option you have. At start you have to say, which weeknumber
definition you'll use.


Arvi Laanemets
 
I

itty

Thanks to all, If I want to derive weeknum of any date other than today,
I should modify today with the date I need. Am i right?
Itty
 
Top