Thread: Calculating Employee hours for the current week
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
lunastu lunastu is offline
external usenet poster
  
Posts: 3
Default Calculating Employee hours for the current week
I think I figured this out.

The formula is:

=INDEX(D10:BD10,1,WEEKNUM(NOW())+1)
Reply With QuoteReply With Quote