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 [TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]MONTH[/TD]
[TD][/TD]
[TD]START DATE[/TD]
[TD]END DATE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]OCT[/TD]
[TD]1-OCT-17[/TD]
[TD]2-OCT-17[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]NOV[/TD]
[TD]1-NOV-17[/TD]
[TD]2-NOV-17[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]DEC[/TD]
[TD]1-DEC-17[/TD]
[TD]2-DEC-17[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]JAN[/TD]
[TD]1-JAN-18[/TD]
[TD]2-JAN-18[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]FEB[/TD]
[TD]1-FEB-18[/TD]
[TD]2-FEB-18[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MAR[/TD]
[TD]1-MAR-18[/TD]
[TD]2-MAR-18[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]APR[/TD]
[TD]1-APR-18[/TD]
[TD]2-APR-18[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MAY[/TD]
[TD]1-MAY-18[/TD]
[TD]2-MAY-18[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]JUN[/TD]
[TD]1-JUN-18[/TD]
[TD]2-JUN-18[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]JUL[/TD]
[TD]1-JUL-18[/TD]
[TD]2-JUL-18[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]AUG[/TD]
[TD]1-AUG-18[/TD]
[TD]2-AUG-18[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]SEP[/TD]
[TD]1-SEP-18[/TD]
[TD]2-SEP-18[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]JUL[/TD]
[TD]3-JUL-18[/TD]
[TD]15-JUL-18[/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD]MONTH[/TD]
[TD][/TD]
[TD]START DATE[/TD]
[TD]END DATE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]OCT[/TD]
[TD]1-OCT-17[/TD]
[TD]2-OCT-17[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]NOV[/TD]
[TD]1-NOV-17[/TD]
[TD]2-NOV-17[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]DEC[/TD]
[TD]1-DEC-17[/TD]
[TD]2-DEC-17[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]JAN[/TD]
[TD]1-JAN-18[/TD]
[TD]2-JAN-18[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]FEB[/TD]
[TD]1-FEB-18[/TD]
[TD]2-FEB-18[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MAR[/TD]
[TD]1-MAR-18[/TD]
[TD]2-MAR-18[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]APR[/TD]
[TD]1-APR-18[/TD]
[TD]2-APR-18[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MAY[/TD]
[TD]1-MAY-18[/TD]
[TD]2-MAY-18[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]JUN[/TD]
[TD]1-JUN-18[/TD]
[TD]2-JUN-18[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]JUL[/TD]
[TD]1-JUL-18[/TD]
[TD]2-JUL-18[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]AUG[/TD]
[TD]1-AUG-18[/TD]
[TD]2-AUG-18[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]SEP[/TD]
[TD]1-SEP-18[/TD]
[TD]2-SEP-18[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD]JUL[/TD]
[TD]3-JUL-18[/TD]
[TD]15-JUL-18[/TD]
[/TR]
</tbody>[/TABLE]
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.