Conditional formating between multiple dates

[jamafama]

Hello everyone, I am using excel 2007 and have meeting dates on the header row and leave and return dates in columns P and Q. I would like the information in cells to be highlighted if it is between the leave and return date. I made an example of what I have below. Please let me know if you have any questions. Thank you already for your help and this wonderful forum.<table style="border-collapse: collapse; width: 548pt;" border="0" cellpadding="0" cellspacing="0" width="730"><col style="width: 38pt;" width="51"><col style="width: 44pt;" width="58"><col style="width: 26pt;" width="35"><col style="width: 38pt;" width="50"><col style="width: 26pt;" width="35"><col style="width: 29pt;" width="38"><col style="width: 26pt;" width="35"><col style="width: 29pt;" width="38"><col style="width: 26pt;" width="35"><col style="width: 29pt;" width="38"><col style="width: 26pt;" width="35"><col style="width: 29pt;" width="38"><col style="width: 26pt;" span="2" width="35"><col style="width: 56pt;" span="2" width="75"><col style="width: 18pt;" width="24"><tbody><tr style="height: 80.25pt;" height="107"> <td class="xl66" style="height: 80.25pt; width: 38pt;" width="51" height="107">Sunday, 11/29/09</td> <td class="xl66" style="border-left: medium none; width: 44pt;" width="58">Thursday, 12/03/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 12/06/09</td> <td class="xl66" style="border-left: medium none; width: 38pt;" width="50">Thursday, 12/10/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 12/13/09</td> <td class="xl66" style="border-left: medium none; width: 29pt;" width="38">Thursday, 12/03/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 12/06/09</td> <td class="xl66" style="border-left: medium none; width: 29pt;" width="38">Thursday, 12/17/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 12/20/09</td> <td class="xl66" style="border-left: medium none; width: 29pt;" width="38">Thursday, 12/24/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 12/27/09</td> <td class="xl66" style="border-left: medium none; width: 29pt;" width="38">Thursday, 12/31/09</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Sunday, 01/03/10</td> <td class="xl66" style="border-left: medium none; width: 26pt;" width="35">Thursday, 01/07/10</td> <td class="xl67" style="border-left: medium none; width: 56pt;" width="75">Leave Date</td> <td class="xl67" style="border-left: medium none; width: 56pt;" width="75">Return Date</td> <td style="width: 18pt;" width="24">
</td> </tr></tbody></table>

 

[jamafama]

I figure it must be something like: ="IF(DATE(P:P)<=DATE("""":6)>=DATE(Q,"""")"
Please let me know if I am on the right track, Thanks