syntax:functions:addmonths
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
syntax:functions:addmonths [2015/04/03 19:41] – elenap | syntax:functions:addmonths [2021/08/30 00:06] – [Remarks] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== AddMonths(date_as_number, N) ===== | + | ====== AddMonths(date, add_months) ====== |
+ | Category: | ||
- | Adds //N// months to a date. In //expression// represent date as number. //N// can be in range from -10000 to 10000. | + | \\ |
+ | =====Description===== | ||
+ | This function adds //add_months// number of months to //date//. | ||
- | ^ | + | \\ |
- | | addmonths(42097, 3) | + | =====Arguments===== |
+ | ^Argument^Type^Description^ | ||
+ | |date|Date or Number (date serial)|A expression representing a date. See " | ||
+ | |add_months |Number |The number of months to be added to //date//, or subtracted if negative.| | ||
+ | |||
+ | **Return value type:** Number (date serial value). | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | The //date// argument can take any value or expression that evaluates to a date serial value, with or without a time portion. | ||
+ | * A date string: | ||
+ | * A date serial value: 43811 (the date serial for " | ||
+ | * A date value created using any of the Date/Time functions that returns a date serial value. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | | ||
+ | |||
+ | addmonths(43811, | ||
+ | |||
+ | addmonths(# | ||
+ | |||
+ | |||
+ | \\ | ||
+ | ===== See also ===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[https:// |
syntax/functions/addmonths.txt · Last modified: 2021/08/30 01:52 by craigt