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, 12 Jan 2011 19:34:05 -0800 > Subject: $$Excel-Macros$$ Re: Formula to add date > From: springer...@gmail.com > To: excel-macros@googlegroups.com > > 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 would be =A1+1. I then copy and paste > that down the column or acroos a row. I have one spreadsheet that > covers the year. I just use a simple =A()+1 and then click on the last > date from the previous sheet. > > Not real high tech and because the months have different #'s of days > there is a little fiddling around to make it how you want it but it > works pretty easily. > > I am sure there is some better way to do it, but that is the thing > about excel, the more I learn, the more I realize how little I know. > > On Jan 12, 12:20 am, "Susan" <susan.m.ander...@comcast.net> wrote: > > Hi, > > > > I'm looking for a formula that will add all dates of the month. It will > > auto-populate for me the next day in the month. > > > > Column A > > > > 01/01/2011 > > > > 01/02/2011 > > > > 01/03/2011 > > > > Etc, etc > > > > I am creating templates at work that all 12 templates need dates according > > to the month for column A: 01/01/2011 to 01/31/2011. Instead of manually > > typing all of the dates in column A1 to A31. Is there a formula to put in > > column A1 that will start with 01/01/2011 and I drag it down to finish at > > 01/31/2011. I tried =DATE(year,month,day)+1. It didn't work. > > > > Thanks much! > > > > ~Susan > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
