I'm trying to use auto fill for a column of dates. But when I use the fill
series command (with day selected as date unit and step value 1) it changes
the year instead of the day.

Make sure you enter real dates.

And you may want to try filling in two dates
then select both cells and drag that down (or edit|fill)

malewis48 wrote:

I'm trying to use auto fill for a column of dates. But when I use the fill
series command (with day selected as date unit and step value 1) it changes
the year instead of the day.

--

Dave Peterson

The date I'm using is 01/27/08. I tried filling in the next one (01/28/08)
and dragging them both down and the day changed but the year did as well. I
tried the auto fill and only the year changes.

"malewis48" wrote:

I'm trying to use auto fill for a column of dates. But when I use the fill
series command (with day selected as date unit and step value 1) it changes
the year instead of the day.

After you type in those values, try formatting the cells in an unambiguous date
format (like: mmmm dd, yyyy).

If the display doesn't change, you're not typing dates.

That could mean that the cells were preformatted as text (reformat as General
and retype the dates).

Or it could mean that you're not typing the month, day, year in the correct
order. Make sure you match the same mdy order as your windows regional setting.

malewis48 wrote:

The date I'm using is 01/27/08. I tried filling in the next one (01/28/08)
and dragging them both down and the day changed but the year did as well. I
tried the auto fill and only the year changes.

"malewis48" wrote:

I'm trying to use auto fill for a column of dates. But when I use the fill
series command (with day selected as date unit and step value 1) it changes
the year instead of the day.

--

Dave Peterson