Thread: WEEKNUM calculations for week stating with Tuesday
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default WEEKNUM calculations for week stating with Tuesday
On Wed, 11 Jun 2008 02:14:00 -0700, P C Verma <P C
wrote:

While calculating WEEKNUM stating from Tuesday to Friday i am getting error
massage #NUM# but for week staring from Sunday and Monday it calculating
correctly. What could be the reason and how to work around it correctly.

IF you are doing what I think you are, you are using an unacceptable argument
for the return_type argument in the WEEKNUM function. Although not entirely
clear in the HELP documentation, the ONLY acceptable arguments are 1 or 2 (or
left blank in which case '1' is understood).

What are you trying to do?
--ron
Reply With QuoteReply With Quote