Populate dates diffence

[expert40]

Hi Team,
I have two cells one is having startdate and other is having enddate.
Ex:startdate=8/21/2013 enddate=8/26/2013
Now what the plan is to find the difference between the two dates and populate in the cells in excel.
i.e. now difference is 6days including start and enddate
I want to populate first date 8/21/2013 in B4,second 8/22 /2013in E4,third 8/23/2013 in H4 and so on until enddate comes.
Please sugget me the way to proceed.I used auto fill to populate the date values taking the difference.
And i also want the date to be like Aug_21 for 8/21/2013
But its not considering the date it incrementing and printing Aug_32 also if startdate is 8/21/2013 and enddate is 9/01/2013


8/21/2013 8/26/2013
Aug_21 Aug_22 Aug_23
I c co I c co I c co



Thanks in advance

[martindwilson]

try like this

[expert40]

Hi Martin,
The formula is working fine.But i am pointing the Aug_21 in cell to get values for other sheet with name Aug_21.At that time i am unable to get the value as Aug_21 instead i am getting as date.Is there any possibility to change the Aug_21 as string to refer other sheets.
Thanks in advance.

[martindwilson]

with a date in say a1 of 27/08/2013

=text(a1,"mmm"\_"dd") will return a text value which you can then use with indirect to refer to another sheet

=INDIRECT(TEXT(A1,"mmm\_dd")&"!b1") would give the value of b1 in sheet name Aug_27!
ie
=Aug_27!B1