My fiscal year starts on July 29th and I have a total of 52 weeks in a year. Sunday is considered the first day of the week. How do I calculate the week number of a specific date? For instance, if the date is 7/15/2013, the week number should be 51.
My fiscal year starts on July 29th and I have a total of 52 weeks in a year. Sunday is considered the first day of the week. How do I calculate the week number of a specific date? For instance, if the date is 7/15/2013, the week number should be 51.
Try this..
=INT((B1-DATE(YEAR(B1+156)-1,7,29)-WEEKDAY(B1))/7)+2
Adaptation of DDL's formula in this thread
http://www.excelforum.com/excel-gene...html?p=3311103
Life's a spreadsheet, Excel!
Say thanks, Click *
try setting up a lookup table in a seperate tab so when you enter a date the week number will pull from the lookup table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks