Help in writing formula in excel to produce dates based on start date and end date

Please help in writing a formula so date can be produced based on selected start date and end date.

For example ; if i choose start date in cell G2 as "01/01/2014" and end date in cell H2 as " 30/06/2014". in Column A date should produced from jan 1 to June 30.

For feb it should stop at 28/02/2014 and for 30 days month, produce 30 days , 31 days month produce 31 days.

sheet attached.

thanks,

JP

HI,

Is this what u r looking for ?

Punnam

Thanks Punnam !

I am looking for formula should able to produce dates based on start date and keep producing till selected end date.

if i choose date between jan 1, 2014 and june 30,2014, then it should able to produce 180 days date.

thanks.
JP

can u drag the formula up to certain row and keep to fixed ?
Punnam

Thanks Punnam ! It is working now.

Welcome
If solved, mark the thread solved using thread tools.
Other way of saying thank is adding reputation points to one who helped you this can be done by using the "Star button"

Punnam