Need to convert "Data-Interest" from Monthly data to Quarterly Data. Attach file.
Quarter 1 - July,Aug,Sep ---> Result: Sep Year
Quarter 2- Oct,Nov,Dec ---> Result: Dec Year
Quarter 3-Jan, Feb, March ---> Result: March Year
Quarter 4-April,May,June ---> Result: June Year
Please help me?
Last edited by shantanu97; 08-27-2020 at 02:46 AM.
Try this:
="Quarter "&CEILING(MONTH(EDATE(A2,6))/3,1)
Or try:
="Quarter "&CHOOSE(MONTH(A2),3,3,3,4,4,4,1,1,1,2,2,2)
How to change values that is giving in different column?
If you want 1-Jul-69 become Sep 69:
=TEXT(CEILING(MONTH(A2+15)*30,89),"mmm")&TEXT(A2," yy")
Last edited by bebo021999; 08-27-2020 at 03:44 AM.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks