day/date/year all together

's Computer Specifications

can I enter a day into my date & year and then drag to auto fill if so how?

's Computer Specifications

Not sure what you want, but how about formatting the date as Custom

dddd, mmmm yyyy

Gord Dibben MS Excel MVP

On Mon, 3 Jul 2006 16:08:01 -0700, Dumber than a pocket full of rocks
<(E-Mail Removed)> wrote:

>can I enter a day into my date & year and then drag to auto fill if so how?

's Computer Specifications

Hi,

enter the date 04/Jul/2006 for eg

click on the little black squre on the right down of the selected cell end
drag to auto fill

hth
regards from Brazil
Marcelo

"Dumber than a pocket full of rocks" escreveu:

> can I enter a day into my date & year and then drag to auto fill if so how?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to call first date of the year and last date of the year	Irshad Alam	Microsoft Access Form Coding	2	15th Apr 2010 09:01 PM
Compare this year/qtr/mo to date with prior year/qtr/mo to date	BMoroneso	Microsoft Access Reports	1	10th Dec 2007 11:28 PM
Adding a year to a date using Year() in update query	=?Utf-8?B?RGF2ZSBL?=	Microsoft Access Queries	1	13th Jan 2006 11:17 PM
Date value in page header for a year ago (month and year only)	=?Utf-8?B?Q2h1Y2tX?=	Microsoft Access Reports	5	20th May 2005 11:49 PM
when I type the year I get autosuggested year-month-date how do I.	=?Utf-8?B?cmF2c2FyYWg=?=	Microsoft Word Document Management	1	11th Nov 2004 12:19 AM