Dear all,
My idea is to make an column with months numbers and then a column where it tells me what quarter the months is in.
Udklip.PNG
Can someone be helpful in this matter?
Thanks in advance!
/Soren
Dear all,
My idea is to make an column with months numbers and then a column where it tells me what quarter the months is in.
Udklip.PNG
Can someone be helpful in this matter?
Thanks in advance!
/Soren
Hi Soren and welcome to the forum,
I'd use a VLookup() function for this problem. See if the attached makes sense to you.
VLookup Date Month Quarter.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
welcome to the forum, Soren. try:
=CEILING(A1/3,1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks