excelforum.xlsx
I am trying to create a statement that would look at cells A2 and pick off the first two (2) numbers (Months) and drop either cells F15 or F16 into the corresponding location at F2. The same is true for A3:A13. I need the formatting to follow.
Example: Cell A2 is 05/25/2010. I need cell F2 to recongize the 05 on the beginning of A2 and decide that its a summer month, and hence enter the value of cell F15 into cell F2.
The parameters are: Summer consists of May through September or 05, 06, 07, 08, 09 . Winter comprises the other 7 months.
If I knew what function to start with, I could complete the code. Im just stumped. thanks again!
Bookmarks