Quote:
Originally Posted by Mazzaropi
--------------------------------------------------------------------------
Dear NISMOjim, Good Morning
You donīt need to use another colunm to control monthīs date.
Try this one: IF(AND(MONTH(A1)=4,C1="JOE"),1,0)
Use the monthīs number.(1=Jan;2=Feb;3=Mar...)
|
Works perfect. Thanks so much for the help, and I'm sure I will be back with more questions.