Date to Pre Fill

's Computer Specifications

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!

's Computer Specifications

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

=A10+1

--
Biff
Microsoft Excel MVP

"Bet101" <(E-Mail Removed)> wrote in message
news:25E6D6A8-B868-4C29-B2AE-(E-Mail Removed)...
>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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting a fill color on a certain date	Eric	Microsoft Excel Worksheet Functions	2	1st Jan 2008 06:34 AM
Enter Start Date and Auto Fill the End Date	=?Utf-8?B?SmV0?=	Microsoft Access Queries	3	16th Apr 2007 08:52 PM
Date Fill	martins	Microsoft Excel New Users	7	6th Aug 2006 07:20 AM
date fill-in	Charlie Klein	Microsoft Access Form Coding	2	11th Aug 2004 11:04 PM
Date created field (auto current date fill-in)	Lauri	Microsoft Access Forms	3	13th Jul 2004 08:43 PM