Calculating Quarters from Dates
you can use VLOOKUP. create a column next to your date. in that column,
format the date to be MM-YYYY. Create a VLOOKUP table that has one column of
MM-YYYY and the other column of NQtrYY
"dwake" wrote:
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.
|