OK, a couple of things: You're changing date formats. (just so you know) 12/22/2014 is mm/dd/yyyy format 13/12/2014 is dd/mm/yyyy format. Now, it's entirely POSSIBLE to do that, but unusual. Second, my questions still remains. Are you looking for Excel functions, or VBA? Again, remember that the dates are NUMBERs. So, forget that they're "dates". How would you display all the numbers (integers) from 41985 to 41995 ?
--------------------------------- Since I have no idea what your worksheet looks like, or how you want to use this, I can make some assumptions and give you this example: Start date is in cell A1 End Date is in Cell A2 In B1 put =A1+1 in B2 put =IF(B1<>"",IF(B1+1<$A$2,B1+1,""),"") and copy B2 down I'm not sure why your example stops at 12/17... -------------------------------- also, I'm not sure how you think the INDIRECT()function would apply here. INDIRECT() basically takes a string of characters and interprets them as a cell address. For instance, if you had a bunch of values in column A and in cell B1 you had "A3" in Cell C1 the function =INDIRECT(B1) would show you whatever value is in cell A3. because it's "indirectly" interpreting the value in B1 as a cell reference. ------------- Let me know what your worksheet looks like and how you expect these dates to be "returned" and I'll see what I can do to help. 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 7:37 AM >Subject: $$Excel-Macros$$ Re: Dates > > > >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+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.
