Formula to convert a Date to the Week number of the year or quarter
I am trying to find a way to take a date and convert the date to a number that would represent the week number in a calender year or the week number in a calendar quarter. The value could either bring back the week based on a the calendar week or the actual number of days divided by 7 (for example January 5, 2015 is a Monday, but it is in the second week of January, so the result could be week 2 or if the weeks are by actual days, it would be week 1). I have a list of data that includes several years worth of transactions. I would like the logic to work regardless of the year of the transaction. Every year would have a week 1, 2, 3, etc.