The COUPDAYSNC function in Excel calculates the number of days from the settlement date to the next coupon date for a bond. In simple terms, it answers:"How many days are left until the next interest payment?"