Formula for changing calendar date into fiscal weeks

[Ginger_in_need]

Hi all!

This is my first time post. Normally read other's post to help my problems, but I am having trouble this time.

My fiscal year began on Sunday 27, 2017, and has 52 fiscal weeks, and can't figure out this week formula.

I have 46,000 lines of data all with different dates. If a date is between Sept 17, 2017 thru Oct 2, 2017 then I need to spit out week 1, and so on and so forth.

Can any help me with the formula?

Thanks!

 

[barry houdini]

Hello, welcome to MrExcel

If it’s just for this year then you can use this formula

=INT((A2-DATE(2017,9,17))/7

where date is in A2 - format result cell as number with zero decimal places.

If if you want a formula for any year then that’s possible if you have a fixed rule for when year starts