The COUPDAYBS function in Excel calculates the number of days from the beginning of the coupon period to the settlement date of a bond. It’s mainly used when working with bonds and fixed-income securities that pay periodic interest (coupons).