Hello..
I have a column filled with dates in the following format ( 04-2015, 08-2015).
I need to create another column that will separate it by quarters ( Q1, Q2, etc)
what formula will allow me to separate it within 3 months apart for each quarter?
Thank you!
anyone?????????????
Hi There,
You can't have two dates to lookup from single cell.
However, you can refer the following formula to get the quarter. Assuming you have your date in E2 then formula is - "=ROUNDUP(MONTH(E2)/3,0)".
Please let me know if it solve your purpose at some level
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks