Need Excel to recognize week numbers based on specific dates
I need Excel to automatically provide me a week number based off of a starting date (01/01/2017) and other dates to follow. For example, week number 1 starts off with January 2nd 2017 (since the first week of the year starts on the first full week in the month [January 1st would actually fall under week 52]) So any date entered from January 2nd - January 8th would be considered week 1, January 9th - January 15th would be considered week 2, etc...
Can someone help me by developing a formula that suits what I am looking for?
Many thanks!!
|