Return the starting date of a fiscal week

anonumox 

Here are the formulas you can maybe use:

1. To calculate the week number of each date in your data, use this formula:

=INT((A2-DATE(YEAR(A2+7-WEEKDAY(A2-1)),1,1)-WEEKDAY(DATE(YEAR(A2+7-WEEKDAY(A2-1)),1,1),3)+5)/7)

This formula accounts for the NRF 4-5-4 calendar.

2. To add an index for each fiscal week, use this formula:

=IF(WEEKDAY(B2)=1,B2,"")&"-"&TEXT(WEEKNUM(B2),"00")

This formula calculates the difference between each week’s starting date and the starting date of your fiscal year.

3. To multiply the index value by 7 days, simply multiply the cell containing the index value by 7.

I hope that helps!

NikolinoDE

I know I don't know anything (Socrates)