View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Picking every monday from a list of dates

I have a long list with interest rates and dates. The list is for every day
i.e. I have one interest rate for every day. Now I want to pick out the
interest rate for one day per week, say evey monday. Is this possible? if so
how? Is it also possible to pick out the interest rates for just the business
days (i.e. do not show sundays/saturdays)? Any help is very much appreciated!
Thanks alot!