I
itty
Is it possible to derive a formula to use as the excel built in function
"WEEKNUM"
Thanks,
Itty
"WEEKNUM"
Thanks,
Itty
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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)
=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
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
I should modify today with the date I need. Am i right?
Itty
B
Bob Phillips
Yep.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
Dodo
Is it possible to derive a formula to use as the excel built in function
"WEEKNUM"
There is an add-in for Excel here:
http://home.planet.nl/~schni000/Excel/excel.htm
Look for:
Bepaal ISO-Weeknummer dmv =isoweek(datum) of =isoweek(A1)