Cell drag and drop

  • Thread starter Thread starter clara
  • Start date Start date
C

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
 
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
 
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:
 
Thanks for the feedback, glad to help you

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



"clara" escreveu:
 
Back
Top