Date to Pre Fill
 

I am trying to format cells that when you put a date in the dates prefill
across. So if you type in 9-1-08 in A-10; B-10 would read 9-2-08, C-10 would
read 9-3-08 ect ..

Thank you!

Date to Pre Fill
 

Enter this formula in B10 and drag copy across as needed:

=A10+1

--
Biff
Microsoft Excel MVP


"Bet101" wrote in message
...
I am trying to format cells that when you put a date in the dates prefill
across. So if you type in 9-1-08 in A-10; B-10 would read 9-2-08, C-10
would
read 9-3-08 ect ..

Thank you!