I am starting with a month e.g. January 2011 in cell A1 and I want to display the four quarters of 2011 in sepereate cells e.g. Jan - Mar, Apr - Jun, Jul - Sep, Oct - Dec.
Is this possible?
I am starting with a month e.g. January 2011 in cell A1 and I want to display the four quarters of 2011 in sepereate cells e.g. Jan - Mar, Apr - Jun, Jul - Sep, Oct - Dec.
Is this possible?
Last edited by Piper1509; 08-05-2010 at 06:37 AM.
Yes but would be easier to type them in. Do you have Jan 2010 in a separate cell from the 4 cells you want to populate? Is it entered as text or a number?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
January 2011 is in cell A1 but I can change the month January to cell A1 & then the year to cell A2, if this was easier. I want to return the quarter description in cell B5, C5, D5 & E5.
Okay, so whatever month you have in A1 (easier if entire date in 1 cell), you want to measure quarters from that date forward in 3 month intervals?
This should work if A1 is a number formatted as mmmm yyy
In B5, =TEXT(A1,"mmm - ")&TEXT(EDATE(A1,2),"mmm")
In C5, =TEXT(EDATE(A1,3),"mmm - ")&TEXT(EDATE(A1,5),"mmm")
In D5, =TEXT(EDATE(A1,6),"mmm - ")&TEXT(EDATE(A1,8),"mmm")
In E5, =TEXT(EDATE(A1,9),"mmm - ")&TEXT(EDATE(A1,12),"mmm")
Great job, thanks very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks