Hello,

I have a apparently simple issue which shows lots of resistance in spite of lots of research on array formulas and constant arrays.
I have in a1 a date (let s say 12/05/13) and in b1 another date (15/05/13).

In cell B3, I want an array composed of all the dates included in that range.
The result would look like this : {12/05/13,13/05/13,14/05/13,15/05/13}, however I cannot figure what formula I could use.

Also I know this is very easy to do in VBA but this is not the point here.

Thank you to all who can try to help!

Gus