I need to a formula that would produce in column A a running series of dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):
1/03/2004
1/04/2004
1/05/2004
etc....
Thank you for any help!
I need to a formula that would produce in column A a running series of dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):
1/03/2004
1/04/2004
1/05/2004
etc....
Thank you for any help!
Carol, you can put 1-3-04 in A1 and use the fill handle and drag it down,
the little black box in the lower right hand corner, if you do need a
formula here is one way with your starting date in A1 put this in A2 and
drag down =A1+1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Carol" <Carol@discussions.microsoft.com> wrote in message
news:F90CC266-918A-409A-8377-012BECD364EA@microsoft.com...
> I need to a formula that would produce in column A a running series of
dates
> without having to type them in individually. I need it such as (not
> necesarily in numerical form):
>
> 1/03/2004
> 1/04/2004
> 1/05/2004
> etc....
>
> Thank you for any help!
>
Thank you!!!!!!!!! And you know, it's sad... I remember this formula from
the early days of Lotus now! It's just been too long ago. Thank you again.
"Paul B" wrote:
> Carol, you can put 1-3-04 in A1 and use the fill handle and drag it down,
> the little black box in the lower right hand corner, if you do need a
> formula here is one way with your starting date in A1 put this in A2 and
> drag down =A1+1
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Carol" <Carol@discussions.microsoft.com> wrote in message
> news:F90CC266-918A-409A-8377-012BECD364EA@microsoft.com...
> > I need to a formula that would produce in column A a running series of
> dates
> > without having to type them in individually. I need it such as (not
> > necesarily in numerical form):
> >
> > 1/03/2004
> > 1/04/2004
> > 1/05/2004
> > etc....
> >
> > Thank you for any help!
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks