## formula

Note: The advice in this article addresses how to accomplish this for states that have only one time zone. It won't work for states with multiple time zones.

Have you ever called a customer at 9:00 AM on the East coast only to find that your customer is on the West coast and its 6:00 AM and you just woke them? This happens all the time.

December 13th, 2009 - 12:12 PM
Returns the user's e-mail address. This function won't work for users who have hidden their e-mail address.
October 14th, 2009 - 4:10 PM
Tags:
Returns a given user's full name. Specify text format by including "FF" to return the full name with the first name first. Or, include "LF" to return the full name with the last name first.
October 14th, 2009 - 4:10 PM
Tags:
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: