Jeff
Thank you for your reply, unfortunately it does not work. I am trying to calculate if an existing date is in 1 academic year or another, so I adapted you suggestion but but both of these return Last Year when they should display the 2 results. Any further thoughts would be appreciated.
<table style="width: 197pt; border-collapse: collapse;" x:str="" border="0" cellpadding="0" cellspacing="0" width="262"><colgroup><col style="width: 67pt;" width="89"><col style="width: 48pt;" width="64"><col style="width: 82pt;" width="109"></colgroup><tbody><tr style="height: 12.75pt;" height="17"><td class="xl24" id="td_post_1872370" style="border: medium none rgb(236, 233, 216); width: 67pt; height: 12.75pt; background-color: transparent;" x:num="39691" align="right" width="89" height="17">31/08/2008</td><td style="border: medium none rgb(236, 233, 216); width: 48pt; background-color: transparent;" width="64">
</td><td class="xl25" style="border: medium none rgb(236, 233, 216); width: 82pt; background-color: transparent;" x:str="'=IF(DATE(2008,8,31) <= F2,"Last Year","This Year")" width="109">=IF(DATE(2008,8,31) <= F2,"Last Year","This Year")
</td></tr><tr style="height: 12.75pt;" height="17"><td class="xl24" style="border: medium none rgb(236, 233, 216); height: 12.75pt; background-color: transparent;" x:num="39721" align="right" height="17">30/09/2008</td><td style="border: medium none rgb(236, 233, 216); background-color: transparent;">
</td><td class="xl25" style="border: medium none rgb(236, 233, 216); background-color: transparent;" x:str="'=IF(DATE(2008,8,31) <= F3,"Last Year","This Year")">=IF(DATE(2008,8,31) <= F3,"Last Year","This Year")</td></tr></tbody></table>