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
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
Last edited:
