array filling same information

[leem]

I'm not doing something right but I can not figure out what is happening. In cell c2 I type in =Transpose(dates) and turn to an array. Grab the corner, drag right and I keep keeping the same date instead going up 1 month. This is the dates formula - "=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A$1:$A$65389)-23,0,24,1)"

My results should be c2 is Jan 14, d2 is Feb 14, d3 is Mar 14, etc. Please set straight. Thank you for your time and knowledge.

Thanks
Michelle

[Tony Valko]

You don't need the TRANSPOSE function.

Try it like this...

=INDEX(OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A$1:$A$65389)-23,0,24,1),COLUMNS($C2:C2))

[samba_ravi]

use the following formula for name manager
=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1)
see the attached file

[leem]

Tony,
Thank you so much. This worked great. Thank you for sharing your knowledge.

Michelle

[leem]

nflsales,
Thank you so much for replying, I could not make this work. Maybe I can not drag correctly or something. I reattached your file to show you what happens when I put in the formula and I'm set to automatic calculations.

Thanks
Michelle

[leem]

Nflsales, I'm sorry, I forgot to thank you for sharing your knowledge with me. Thank you for taking the time to look at my problem and sharing your knowledge.

[Tony Valko]

You're welcome. Thanks for the feedback!