Date problem

[Greg]

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

 

[Norman Jones]

Hi Greg,

Try:

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

 

[Harald Staff]

Hi Norman

I believe you mean
=IF(MONTH(TODAY())<=6,"Yes","No")

Greg: Yes/no to what ? This makes me very curious

Best wishes Harald

 

[Norman Jones]

Hi Harald,

I believe you mean
=IF(MONTH(TODAY())<=6,"Yes","No")

Indeed!

Thank you.

 

[Greg]

I am "trying" to an excel database for a league my sister runs, it is ran in
two seasons so instead of yes and no it will be summer , winter. just
thought it would be easier with the yes no direction.
She has to order the trophies and print out the forms so I want to have it
do this part automatically for her.

Thanks for your help
Greg

 

[Harald Staff]

I see. Neat idea. Thanks Greg.

Best wishes Harald