tycasey17
Board Regular
- Joined
- Sep 26, 2013
- Messages
- 93
- Office Version
- 2019
- 2016
- Platform
- Windows
So I have a table with all my yearly information on one tab and to feed another tab
<tbody>
</tbody>I use the VLOOKUP function to based on the month. I am curious if anyone has a formula or something to where it could recognize the dates instead. Im in the military and it would be for our Annual Training but I dont want that to interfere with the JAN-DEC table.
MONTH | START DATE | END DATE | |
10 | OCT | 1-OCT-17 | 2-OCT-17 |
11 | NOV | 1-NOV-17 | 2-NOV-17 |
12 | DEC | 1-DEC-17 | 2-DEC-17 |
1 | JAN | 1-JAN-18 | 2-JAN-18 |
2 | FEB | 1-FEB-18 | 2-FEB-18 |
3 | MAR | 1-MAR-18 | 2-MAR-18 |
4 | APR | 1-APR-18 | 2-APR-18 |
5 | MAY | 1-MAY-18 | 2-MAY-18 |
6 | JUN | 1-JUN-18 | 2-JUN-18 |
7 | JUL | 1-JUL-18 | 2-JUL-18 |
8 | AUG | 1-AUG-18 | 2-AUG-18 |
9 | SEP | 1-SEP-18 | 2-SEP-18 |
AT | JUL | 3-JUL-18 | 15-JUL-18 |
<tbody>
</tbody>