Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • Returns the user's full name, first name first.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the date that is n weekdays past the given date d. n may be negative to move backward in time.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the date obtained by adding n weekdays to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/03/2003 since it counts 10/31/2003 as 1 day and 11/03/2003 (a Monday) as the second day.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the number of weekdays in the interval starting with d1 and ending on the day before d2 (same as subtracting Dates, but the result is the number of weekdays instead of a Duration). It is the inverse of WeekdayAdd.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the date obtained by adding n days to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/01/2003 since it counts 10/31/2003 as 1 day and 11/01/2003 (a Saturday) as the second day.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the date obtained by adding n days to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/01/2003 since it counts 10/31/2003 as 1 day and 11/01/2003 (a Saturday) as the second day.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Converts a date d to a WorkDate.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns t with leading and trailing white space characters removed. White space characters are space, tab, CR and LF.
    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