OK, I read your question.. all of them. and have NO idea what you're asking for. The problem here is that you have a worksheet in front of you that has stuff on it. I have a blank worksheet. The ONLY thing I can put on the sheet is what you tell me. You said you wanted the NUMBER of dates between two dates. Then you said "10 days should be shown in number of rows" That's not a number, that's showing actual dates. So, evidently we're not communicating. Are you saying you have a sheet that has a date column and you want to highlight the dates that are between two dates? if THAT's the case, then you can possibly use Conditional Formatting. otherwise, can you send me a sample sheet showing what you have and what you want it to do?
Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- >________________________________ > From: Mandeep Baluja <rockerna...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Friday, December 12, 2014 8:01 AM >Subject: Re: $$Excel-Macros$$ Re: Dates > > > >Request Please read my question It's not about getting number of Days between >two dates. > > >See dis what i want. > > > Like Start date >A1 >12/12/2014 >end date > >B1 >12/22/2014 > >Formula should return in number of rows. >C1,c2,c3,c4,c5 > >want this Broo..... >13/12/2014 >14/12/2014 >15/12/2014 >16/12/2014 >17/12/2014 > > > > > > > > > > > > > > > > > > > >On Friday, December 12, 2014 6:23:45 PM UTC+5:30, Pol Ktk wrote: >Sir, >>Check this >> >> >> >> >> >> >> >>On Fri, Dec 12, 2014 at 6:07 PM, Mandeep Baluja <rocke...@gmail.com> wrote: >>Hey paul, >>> >>> >>>Thanks for reply I have highlighted number of Dates not days. I want number >>>of dates between two dates. >>> >>> >>>Like Start date >>>12/12/2014 >>>end date >>> >>>12/22/2014 >>> >>>Formula should return 13/12/2014 >>>14/12/2014 >>>15/12/2014 >>>16/12/2014 >>>17/12/2014 >>> >>>Want to retrieve this. I have an idea indirect function will be used in >>>this. >>> >>> >>>-- >>>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...@ googlegroups.com. >>>To post to this group, send email to excel-...@googlegroups.com. >>> >>> >>> >>> >>>Visit this group at http://groups.google.com/group/excel-macros. >>>For more options, visit https://groups.google.com/d/optout. >>> >-- >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. > > > -- 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.
