| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number - Fiscal Year
How would i pull week numbers for our fiscal year, which starts 07/01?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get month number for fiscal year starting in Oct. | Excel Worksheet Functions | |||
| Define fiscal year | Excel Worksheet Functions | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Finding the date using the number of the week in a year | Excel Worksheet Functions | |||
| Fiscal Year Calculation | Excel Worksheet Functions | |||
Linear Mode
