Creating a Fiscal Week Lookup Table

DPChristman

Board Regular
Joined
Sep 4, 2012
Messages
126
I am trying to create a fiscal week lookup table for a spreadsheet I am working on. My boss needs TY/LY weekly comparison.
I have tried to use the =weeknum(b1) command. However, our first fiscal week is 2/3/19-2/9/19, so the value returned using that formula is 6.
I am able to get it to read 1 by changing the formula to =weeknum(b1)-5.
However, three days into week 48 (Tues 12/31), the formula reports a value of '(4)' and decreases weekly to 0 on 1/26
I know I can override the formulas with manual entries for the last few weeks, but I would like it to work properly
 
Last edited:

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

DPChristman

Board Regular
Joined
Sep 4, 2012
Messages
126
Thanks. That works.
However, it gives me 53 weeks and we have a 52 Week fiscal year
So I just changed the 53 in the formula to 52, and it gives me exactly what I need
 

Watch MrExcel Video

Forum statistics

Threads
1,090,490
Messages
5,414,849
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top