Hi Greg,

Try:

=IF(MONTH(TODAY())=6,"Yes","No")


---
Regards,
Norman



"Greg" wrote in message
...
Hi all,
I have a question concerning a cell, I want the cell to lookup the date if
it is between jan 1 and june 30 I want it to show "yes" and no for the
rest
of the year. I need it to be volitile and not just for this year.

Any ideas

Thanks

Greg