Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Quarters from Dates
I am looking at showing the quarter a selective date is in i.e. 9-Dec-09
would be 4Qtr09.s Any code that can do this without having to go in to do it manually? The amount of data in the column is also constantly changing so I would need the code to loop until the end of the data. Any help would be appreciated. Date Quarter 9-Dec-09 4Qtr09 1-Jan-10 1Qtr10 The data in these columns are generated using a macro and will not always have the same number of rows. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lumping dates into quarters by year | Excel Worksheet Functions | |||
Calculating quarters of a year. | Excel Worksheet Functions | |||
sumif between dates (quarters) | Excel Worksheet Functions | |||
Formatting of dates into quarters | Excel Discussion (Misc queries) | |||
How do I Turning Dates into Quarters | Excel Worksheet Functions |