AnnDateSeq | ||||||||
Data Type: Annual Sequence | ||||||||
A range (either one or range of cells) consisting of annual sequence numbers in the format mm.dd such as 01.31 (for 1st January) or 12.25 (for December 25th) | ||||||||
An annual date sequence is a recurring pattern of annual dates, expressed in a way that Business Functions understands. For example, Jan 1st, July 1st, every year, is {1.01,7.01}. | ||||||||
Example: {1.15,7.15} | ||||||||
Variable Values | ||||||||
Switches | ||||||||
-12 | Last day of the month (February: 28 or 29) | |||||||
-4 | 31st March, 30th June, 30th September and 31st December of each year | |||||||
-2 | 31st July and 31st December of each year | |||||||
-1 | 31st December of each year | |||||||
1 | 1st January of each year | |||||||
2 | 1st January and 1st July of each year | |||||||
4 | 1st January, 1st April, 1st July and 1st October of each year (also Real Estate US quarter days) | |||||||
12 | 1st day of the month | |||||||
14 | Continuous (could be thought of as daily) |