Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • Returns the month number of the Date d. January is month 1.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the millisecond part of the argument t. The millisecond is in the range 0 to 999.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns a Duration representing n milliseconds. This function takes a number and converts it into a Duration type value, expressed in milliseconds.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the first day after the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the logical negation of b (if b is true, returns false, otherwise returns true).
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments. Null values are ignored. For Numbers, returns the argument that is greatest. For Text, returns the argument that sorts last alphabetically. For Durations, returns the argument that is longest. For Dates returns the argument that is latest. For Date/Time, returns the argument that is latest. For TimeOfDays, returns the argument that is latest. For Booleans returns the argument that is largest, treating false as less than true.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the left part of a text value up to but not including the first occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the number of characters in t.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Concatenates (strings together) all arguments starting with the second argument, using the first argument as the delimiter between them. If one of the arguments is blank, it and the corresponding delimiter are omitted.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the natural (base e) logarithm of n.
    October 14th, 2009 - 4:10 PM
    Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit