LinkBack URL
About LinkBacks
Using Glenn's formula
=MOD(INT((A1-DATE(2016,1,30))/7),13)+1
Will give Weeks 1 to 13 for each quarter i.e Week 14 is Week 1 of Quarter 2
Is this what you require?
Using Glenn's formula
=MOD(INT((A1-DATE(2016,1,30))/7),13)+1
Will give Weeks 1 to 13 for each quarter i.e Week 14 is Week 1 of Quarter 2
Is this what you require?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks