Hello Welcome to the Forums,
onAfteChange, e.site is different from e.source node. If you want exact rowNumber count for new row and modifying the node means you have to use the below code,
IXMLDOMNode parentNode = e.parentNode;
int rowNumber = parentNode.selectNodes("preceding-sibling::my:LeaveEntry/my:startDate").length + 1;