Thread: Week Number - Fiscal Year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
  
Posts: 143
Default Week Number - Fiscal Year
How would i pull week numbers for our fiscal year, which starts 07/01?

If column A contains a list of dates, one way is to put this in B1 and copy
down:
=ROUNDUP((A1-DATEVALUE("07/01/09")+1)/7,0)
Reply With QuoteReply With Quote