Question
May 9, 2007 at 06:45 AM
lharwell

autofill dates in sequence in excel

by lharwell . Updated 19 years ago

I am creating a spreadsheet that will need to have dates autofilled. I need each day of the month in sequence with each day entered 3 times to signify 3 shifts. For example:

06/01/07
06/01/07
06/01/07
06/02/07
06/02/07
06/02/07

to the end of each month. There will be a new workbook for each month & there will be several worksheets (tabs) in each monthly workbook. Is it possible for excel to autofill this way?

This discussion is locked

All Comments