Dear All, I want to calculate date wise grouping of month closing Like:- i have data of student Raw Data ID Student name Course Date of Registration Closing Dates From To Month 3001 Sanjay English 01-01-2014 01-01-2014 26-01-2014 Jan 3002 Anil Hindi 02-01-2014 Lookup Dates 27-01-2014 28-02-2014 Feb 3003 Prakash English 16-01-2014 01-03-2014 27-03-2014 Mar 3004 Sunil Hindi 23-01-2014 3005 Happy English 27-01-2014 3006 Lovely Hindi 29-01-2014 3007 Arun English 01-02-2014 3008 Pankaj Hindi 15-02-2014 Result 3009 Amit English 28-02-2014 Month Jan Feb Mar Total 3010 Karan Hindi 01-03-2014 Count of Students 4 5 1 10
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.