Thread: duration days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack nelson jack nelson is offline
external usenet poster
 
Posts: 1
Default duration days

hi all
i want to ask about this calculation:
if i have a date for sell and the date for billing and i want to caculate
the diffrence between them with a quirey if the days more than 10 days the
result no discount and if it is less than 10 days it eill be extra discount
like 3% and if the days more than 20 days that means tax 10% can any body
help me?