I would like to incorporate a function in a table but I am novice in this area and I really need your help. In my database, I have a column number entitled of contract and 3 other columns for different periods of this market (period1: 05 July 2006 to July 04, 2007, period 2: 05 July 2007 to 04 July 2008 etc). I hope that the period of the market is automated in another sheet. So I created a formula that will give me the market depending on the date. I guess it's like, if date is = or <dates of the first period of the contract; "1" etc as this comparison should be made on the 3 periods of the market. Thank you in advance for your help.
Bookmarks