Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
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" skrev i melding ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
Hi Harald,
I believe you mean =IF(MONTH(TODAY())<=6,"Yes","No") Indeed! Thank you. --- Regards, Norman "Harald Staff" wrote in message ... 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" skrev i melding ... Hi Greg, Try: =IF(MONTH(TODAY())=6,"Yes","No") --- Regards, Norman |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
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" wrote in message ... 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" skrev i melding ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
I see. Neat idea. Thanks Greg.
Best wishes Harald "Greg" skrev i melding ... 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" wrote in message ... 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" skrev i melding ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date problem | Excel Discussion (Misc queries) | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Date problem | Excel Discussion (Misc queries) | |||
Another Date problem | Excel Programming |