| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert a specific date to a fiscal quarter ?
In a sales spreadsheet, the sale date is represented as a specific day
date...i.e 7/12/2006. I want to convert that date into a representative quarter...like Q1FY07. I tried formating the date as a month-year( Jul-06 ) and then doing a find/replace to replace all Jul-06 with Q1FY07...but the date in the field is actually still 7/12/2006, just formatted as Jul-06....so Find/Replace finds 0 records....help !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fiscal Quarter Conversion | Excel Worksheet Functions | |||
| fiscal quarter conversion | Excel Discussion (Misc queries) | |||
| How do I convert Julian date to fiscal date | Excel Worksheet Functions | |||
| fiscal quarter data validation | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
