Fiscal Period by Date

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:


Start DateEnd DatePeriod
4/1/184/28/18Period 01
4/29/185/26/18Period 02
5/27/186/23/18Period 03
6/24/187/21/18Period 04
7/22/188/18/18Period 05
8/19/189/15/18Period 06
9/16/1810/13/18Period 07
10/14/1811/10/18Period 08
11/11/1812/8/18Period 09
12/9/181/5/19Period 10
1/6/192/2/19Period 11
2/3/193/2/19Period 12
3/3/193/30/19Period 13

<tbody>
</tbody>
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Assuming that your table is in A1:C14 with headers in row 1, perhaps something like

=LOOKUP(TODAY(),$A$2:$A$14,$C$2:$C$14)
 
Upvote 0
Try a Lookup


Excel 2010
ABCD
1StartPeriodDatePeriod
2Apr 01, 18Period 01Jun 15, 18Period 03
3Apr 29, 18Period 02Jun 15, 18Period 03
5a
Cell Formulas
RangeFormula
D2=LOOKUP(C2,A2:B14)
D3=LOOKUP(C2,{43191,"Period 01";43219,"Period 02";43247,"Period 03";43275,"Period 04";43303,"Period 05";43331,"Period 06";43359,"Period 07";43387,"Period 08";43415,"Period 09";43443,"Period 10";43471,"Period 11";43499,"Period 12";43527,"Period 13"})
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top