| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fiscal Month Formula
Hello
I NEED FISCAL Month I used the weeknum function to determine the week number of the date in column T I added a column at the end labeled 'fiscal month' and I used this formula =IF(T2<5,"Jan",IF(T2<8,"Feb")) but I cannot fit all 12 months in this formula. What formula can I use to determine the fiscal month , I need to use all 12 month from Jan to Dec., or Is there another way to do this? Thanks in Advance |
| 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 | |||
| summing occurances of text by fiscal month | Excel Discussion (Misc queries) | |||
| =month() function equivalent for fiscal calendar | Excel Worksheet Functions | |||
| Defining fiscal month for pivot table | Excel Discussion (Misc queries) | |||
| Formula for Fiscal Year Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
