List All Dates Between Two Dates

[sivaprakasam]

Hi, I am using the EXcel 2013

I need list all dates between two dates based on the start date and end date

I put the formula but not come to the list properly in excel

Kindly provide the excel formula

 

[bosco_yip]

In F2, copied across and down :

=IF(($C2="")+COLUMN(A$1)<=$D2-$C2+1,$C2-1+COLUMN(A$1),"")

 

[sivaprakasam]

S!!! its work... tnq...

 

[sivaprakasam]

I find another one method

In F2, =C2

In G2, copied across and down :

=IF(AND(F2>=$C2,F2<$D2),F2+1,"")

 

[Peter Bartholomew]

Sadly no use to the OP - requires Office 365

 

[sivaprakasam]

tnq

 

[rahulshewale1]

Hi @sivaprakasam

another way .......

In F2, =C2

In G2, copied across and down :

=IF(F2="","",IF((F2+1)<=$D2,F2+1,""))

 

[deciog]

Peter

Really enjoyed

Hugs

Decio