View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
P C Verma P C Verma is offline
external usenet poster
 
Posts: 1
Default WEEKNUM calculations for week stating with Tuesday

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.