I need help setting up date and time in various cells
 

I know how to auto fill and stuff like that, but the dates I am wanting to
fill are on 31 different cells and they are not in a single row or column,
they are sparatic. I was just wanting to enter the date on the first one and
it fill the other 30 with the next 30 days...Thanks

I need help setting up date and time in various cells
 

=A1+1


"Zr2x350" wrote:

I know how to auto fill and stuff like that, but the dates I am wanting to
fill are on 31 different cells and they are not in a single row or column,
they are sparatic. I was just wanting to enter the date on the first one and
it fill the other 30 with the next 30 days...Thanks