Date problem
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
|