thanks for reply mark. your code appears to work well but i need 1 extra help. how can i SUM up the priceusd and gets the peak status? example your...

ok, thanks:-D

E.g:

For the rental period from 1st Sept – 21st Sept 2010

1st – 15th Sept 2010 - USD 1,220 (High) USD 1,220 x 15 Days = 18,300

16th – 21st Sept 2010–...