forum archives  :   Archive home  |   Forum home  |

Softwares & Hardwares

  »

Excel month date year auto fill problem

   ( >> )
Pundit - 03 Feb 2006, 02:16 am
I write in th cell
February 3, 2006
Now, when I drag the selector box downwards, I want the cells to be populated with subsequent dates.

February 4, 2006
February 5, 2006
February 6, 2006

But i get :roll:

February 3, 2007
February 3, 2008
February 3, 2009

Help me please.
Brad - 03 Feb 2006, 06:38 am
Use custom format mmmm dd, yyyy .
shahid_fss - 03 Feb 2006, 10:26 am
HERE IS AN EASY SOLUTUON FOR YOU

Just type 1/1/2004, 1/2/2004, 1/3/2004
Image

Then select all three cells and format them as Date->Marh 1, 2001
Image

Then drag as long as you want
Image