Thread: how to calculate a value for 49 possible combinations
View Single Post
  #2   Report Post  
dlw
 
Posts: n/a
Default
use vlookup to assign numbers to days SUN=1 MON=2, etc then use ABS(arrival
day - departure day) +1
Reply With QuoteReply With Quote