That should not be difficult at all. I am away from home right now but
will return later today and will add it to the spreadsheet. I envision
another table with one row per week and the price for each cottage on
the row. Then a formula in the calendar to determine if it is the
right day and a look up, possibly using index/match again back to the
price table for the price. If we put it on a Tuesday it will apppear
in the middle of the week.

I just realised I can download the spreadsheet from the forum, so I
will do that and repost it.

DOR


--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=487999