jdavid1006
New Member
- Joined
- Oct 21, 2019
- Messages
- 6
Hey everyone,
I'm drawing a blank here. I have a workbook for a company that runs on a 13 period fiscal year rather than monthly periods and I need to look up the period based on the date. What formula can I use to look up a date and return the period?
I have the following:
<tbody>
</tbody>
I'm drawing a blank here. I have a workbook for a company that runs on a 13 period fiscal year rather than monthly periods and I need to look up the period based on the date. What formula can I use to look up a date and return the period?
I have the following:
Start Date | End Date | Period |
4/1/18 | 4/28/18 | Period 01 |
4/29/18 | 5/26/18 | Period 02 |
5/27/18 | 6/23/18 | Period 03 |
6/24/18 | 7/21/18 | Period 04 |
7/22/18 | 8/18/18 | Period 05 |
8/19/18 | 9/15/18 | Period 06 |
9/16/18 | 10/13/18 | Period 07 |
10/14/18 | 11/10/18 | Period 08 |
11/11/18 | 12/8/18 | Period 09 |
12/9/18 | 1/5/19 | Period 10 |
1/6/19 | 2/2/19 | Period 11 |
2/3/19 | 3/2/19 | Period 12 |
3/3/19 | 3/30/19 | Period 13 |
<tbody>
</tbody>