Thread: Date problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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