Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Lookup entire row in Excel
  • Vlookup Examples in Excel
  • Perform case-sensitive Lookup in Excel
  • How to use Excel ROWS Function

Data Analysis Examples

  • How To Insert and Customize Sparklines in Excel
  • Number and Text Filters Examples in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • Excel Pie Chart
  • How to count table rows in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation must begin with
  • Excel Data validation with conditional list
  • Excel Data validation exists in list
  • Excel Data validation allow weekday only

Tag: COUPDAYS function

COUPDAYS function: Description, Usage, Syntax, Examples and Explanation

by

What is COUPDAYS function in Excel? COUPDAYS function is one of the Financial functions in Microsoft Excel that returns the number of days in the coupon period that contains the settlement date. Syntax of COUPDAYS function COUPDAYS(settlement, maturity, frequency, [basis]) The COUPDAYS function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • How to find and replace multiple values at same time in Excel
  • How to split text with delimiter in Excel
  • Remove text by position in a cell in Excel
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • Convert Excel time to Unix time in Excel
  • How to get workdays between dates in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Calculate retirement date in Excel
  • Convert Excel time to decimal hours in Excel
  • Calculate interest for given period in Excel
  • How to calculate principal for given period in Excel
  • Future value vs. Present value examples in Excel
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles