## Formula Function Reference

Our Formula Function Reference

## Formula Function Reference

• 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:
• Returns the year number of the Date d.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the year number of the Date d.
October 14th, 2009 - 4:10 PM
Tags:
• Returns t converted to upper case.
October 14th, 2009 - 4:10 PM
Tags:
• Encodes the text t so that it can be used in a URL, by substituting special character combinations for certain reserved characters, like '&' and '=' and space.
October 14th, 2009 - 4:10 PM
Tags: