# Value dating system single international dating relation

For example, in the formula , the DATE function returns a datetime value equivalent to April 1st of 2008, because 32 days are added to the beginning of March yielding a value of April 1st.

If you enter a negative integer, the following computation occurs: the date is calculated subtracting the value of day from month.

For example, if you have DATE( 2008, -6, 15), the function returns a datetime value equivalent to June 15th of 2007, because when 6 months are subtracted from the beginning of 2008 it yields a value of June 2007. A number representing the day or a calculation according to the following rules: If day is a number from 1 to the last day of the given month then it represents a day of the month.

If you enter an integer larger than last day of the given month, the following computation occurs: the date is calculated by adding the value of day to month.

For example, if you have DATE( 2008, 18, 1), the function returns a datetime value equivalent to June 1st of 2009, because 18 months are added to the beginning of 2008 yielding a value of June 2009. If you enter a negative integer, the following computation occurs: the date is calculated subtracting the value of month from year.The Date Time structure also supports specialized addition methods (such as Add Days, Add Hours, and Add Minutes) for each time interval.The method takes into account leap years and the number of days in a month when performing date arithmetic.For values greater than 9999 or less than zero (negative values), the function returns a #VALUE! If the year value is between , the value is added to 1900 to produce the final value. Note: You should use four digits for the year argument whenever possible to prevent unwanted results.For example, using 07 returns 1907 as the year value.