Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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" wrote in message ... 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! |
#2
|
|||
|
|||
Excel date formulas
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! |
#3
|
|||
|
|||
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" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Excel 2002 date formulas problem | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |