thanks again. Very helpful tips!
On Jan 12, 10:19 pm, Manoj kumar
wrote:
> Hello Guys,
>
> Fill Handle(the small black square on the bottom-right corner of a selected
> range of cells) is one of the best option to fill dates, in fact you can
> fill Days, Weekdays, Months and Years as well.
>
> *
Hello Guys,
Fill Handle(the small black square on the bottom-right corner of a selected
range of cells) is one of the best option to fill dates, in fact you can
fill Days, Weekdays, Months and Years as well.
*Here is the option :- *
Instead of dragging the Fill Handle while holding down the
DEAR FRIEND,
PLEASE TYPE
1/1/11
2/1/11
THEN TAKE BOTH COLUMN IN RANGE AND DRAG
On Thu, Jan 13, 2011 at 7:34 AM, J D wrote:
> I am no whiz kid with Excel but use it all the time. I usually just
> put a date in a cell drop to the next one and add 1. A1 would be the
> date formated how I want, A2
ame color.
Thoughts would be appreciated.
Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: Wednesday, January 12, 2011 8:44 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Formula to add date
Hi,
Not sure if I'm missing the point here, but what about just typing the date
into your first cell, then press enter. From there, select your first cell and
drag the copy-down handle down as far as you want. XL defaults to incrementing
the date one day at a time.
Regards - Dave.
> Date: Wed
