I have a column where information is sorted by date (ie, Nov-07, Jan-08 etc), but I would like to report this information in quarters. For example, November 07 would mean 07-Q3, January 08 would be 08-Q1.
How can I set up a separate column that can draw the month entries and translate them into the quarter entries? I'd really appreciate any help you can give.
To give you a heads up, this is a cross post. You'll want to go to both forums and post links to where you've posted this question otherwise you risk getting banned and/or the thread locked.
Just giving you a heads up. I accidentally made this mistake once too and its an action thats very frowned upon (for good reason of course). In fact I think the issue may have already been resolved over here:
http://www.mrexcel.com/forum/showthread.php?t=322870
Hence the reason cross posting isn't taken lightly.
I use this formula to show quarters as, for example, Q208. You can rearrange to suit.
=IF(A1="", "", "Q" & INT( (MONTH(A1) + 2) / 3) & TEXT(A1, "yy") )
Edit: I posted before seeing fecurtis's comment. Suggest you read and heed his advice, lest you find your future posts at best ignored, and more likely deleted.
Last edited by shg; 06-03-2008 at 06:55 PM.
Heeding fecurtis's advice, here is the link to where I have posted this in the "excel general" section: http://www.excelforum.com/showthread.php?p=1926255
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks