Thread: Weeknum
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Baapi[_5_] Baapi[_5_] is offline
external usenet poster
 
Posts: 1
Default Weeknum


I have a very limited access to internet and the site you have referre
to is blocked under "Free Wares" category.

Anyway, in the mean while I thought of the following logic. But, I'
not sure if this is the perfect one and will work under al
conditions.

(DateSerial (Year(X), Month(X), Day(X) ) - DateSerial (Year(X), 1, 0
)/ 7

Comments? Suggestions

--
Baap
-----------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...fo&userid=2733
View this thread: http://www.excelforum.com/showthread.php?threadid=46836