A dated date marks when interest begins to accrue on a bond or fixed-income security. It’s crucial for bond investors when making purchase decisions.
Excel already knows when the month ends.