Still no baby and my sister just found out she’s pregnant

I am currently 6 days late for my period and my sister is 7 days late. She did not even notice the faint line. It has not even settled in for her and her boyfriend. My husband cried a little but I did not. My husband thought I would be upset because my sister and her boyfriend have only been trying for a month and conceived. My husband and I have been trying for almost two years come October. I’m not upset but very excited and happy for my sister. I feel bad for not crying with my husband but I can not help to be so happy to be an aunt 😬 I hope my husband gets over it and my sister has a wonderful pregnancy. How can I make my husband feel better about this?

UPDATE: sadly my sister miscarried the next night. I have been trying to be there for her but, she acts like it never happened. I feel so bad and sad that I do not know what to do.