View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Digital2k Digital2k is offline
external usenet poster
 
Posts: 24
Default Need formula for date ranges Please & Thanks

I'm in the Insurance business and when I sell a product I have an expected
date that I think it will get approved and get paid. One of the products,
product "M" must get paid before the third Wednesday of the month if not
then it will go the following month.

I want to create a spreadsheet that will automatically make the adjustment
by changing the month paid if the product is product "m" and the expected
date paid is after the third Wednesday of the month. How can I do this?

Please help



Digital2k