Cell drag and drop
 

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
--
thank you so much for your help

Cell drag and drop
 

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


"clara" wrote in message
...
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
--
thank you so much for your help

Cell drag and drop
 

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:

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
--
thank you so much for your help

Cell drag and drop
 

Hi Marcelo,

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

Clara
--
thank you so much for your help


"Marcelo" wrote:

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:

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
--
thank you so much for your help

Cell drag and drop
 

Thanks for the feedback, glad to help you

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



"clara" escreveu:

Hi Marcelo,

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

Clara
--
thank you so much for your help


"Marcelo" wrote:

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:

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
--
thank you so much for your help