Thread: WEEKNUM calculations for week stating with Tuesday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default WEEKNUM calculations for week stating with Tuesday
Maybe

=IF(WEEKDAY(A1,2)1,WEEKNUM(A1,2)+1,WEEKNUM(A1,2))

Mike

"P C Verma" 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.
Reply With QuoteReply With Quote