Thread: I have run out of arguments for nested IF statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default I have run out of arguments for nested IF statement
Sorry, more accurately:

A1: =today()
F3: start date of semester

B1: =WEEKNUM(a1,2)-WEEKNUM($F$3,2)+1

Regards

Hans

Reply With QuoteReply With Quote