COUPDAYSNC

Function Type: Financial

Description:

Returns the number of days from the settlement date to the next coupon date

Function Structure:

=COUPDAYSNC(settlement, maturity, frequency, [basis]).

Argument Breakdown:

settlement – Settlement date of the security.

maturity – Maturity date of the security.

frequency – Number of coupon payments per year (annual = 1, semi-annual = 2, quarterly = 4).

basis – Day count basis.

Example:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->