Week Number - Fiscal Year

M

MyVeryOwnSelf

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
How do I expand a funtion's maximum character length? eg CUBESET 2
How to get month number for fiscal year starting in Oct. 3
Creating a Search using a combo box and then creating a report. 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Define fiscal year 3
End of Quarter Based on Fiscal Year 2

Top