Formulas and Functions Help

• Welcome
• Formulas
  • Formulas overview
  • Add and edit formulas
  • Review formula errors and best practices
  • Copy or move formulas
  • Refer to cells in formulas
  • Use string operators and wildcards
  • Tips for using double quotations in formulas
• Functions
  • Functions overview
  • List of functions by category
  • Types of arguments and values
  • Use string operators and wildcards
  • Tips for selecting financial functions
  • Functions used to round values
  • Functions that accept conditions and wildcards as arguments
• Date and time functions
  • DATE
  • DATEDIF
  • DATEVALUE
  • DAY
  • DAYNAME
  • DAYS360
  • EDATE
  • EOMONTH
  • HOUR
  • ISOWEEKNUM
  • MINUTE
  • MONTH
  • MONTHNAME
  • NETWORKDAYS
  • NOW
  • SECOND
  • TIME
  • TIMEVALUE
  • TODAY
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC
• Duration functions
  • DUR2DAYS
  • DUR2HOURS
  • DUR2MILLISECONDS
  • DUR2MINUTES
  • DUR2SECONDS
  • DUR2WEEKS
  • DURATION
  • STRIPDURATION
• Engineering functions
  • BASETONUM
  • BESSELJ
  • BESSELY
  • BIN2DEC
  • BIN2HEX
  • BIN2OCT