| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I Turning Dates into Quarters
I have a spreadsheet with dates in it (in format mm/dd/yyyy) that I would
like to translate into the appropriate fiscal quarter. For example... Any date between 1/1/2005 and 3/31/2005 = Quarter1 Any date between 4/30/2005 and 6/30/2005 = Quarter2... Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| Filtering with dates | Excel Discussion (Misc queries) | |||
Threaded Mode
