Cell drag and drop

[clara]

Hi all,

I want to use the Cell Drag and Drop to extend date input:

Wednesday Jun 18, 2008
Thursday Jun 19, 2008
Friday Jun 20, 2008

....


How can I do it

Clara

 

[Rick Rothstein \(MVP - VB\)]

Instead of typing in the dates as shown in your posting, type in an actual
date (for example 6/18/2008 or Jun 18, 2008), select the column and Format
Cells using this custom format...

dddd mmm dd, yyyy

That custom format will show the date in the format you want, but the entry
in the cell will be a date, so it can be dragged down.

Rick

 

[Marcelo]

if I have understand what you want.

assuming your first date is in a1.
use in a2 =a1+1 (format as you need)

and drag it down.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"clara" escreveu:

 

[clara]

Hi Marcelo,

It works well. Thank you. You know I like your patriot legend Pele

Clara

 

[Marcelo]

Thanks for the feedback, glad to help you

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"clara" escreveu: