Will my period end after 2 hormone pills?

Which pills? Not all hormone pills are the same. We don't have enough info to answer your question. At age 41 vaginal bleeding can be normal or it can be related to many other things, even endometrial cancer. You need to talk with the doctor that gave you these hormone pills and get more info.