Perfect! Thanks!!

"Gord Dibben" wrote:

Shannon

In B1 enter =IF($A$1="","",A1 + 1)

Drag/copy across row 1


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 15:55:02 -0800, "Shannon"
wrote:

Hi Dave O, Thank you so much! Here's another question that has developed
after I entered that formula. Before I have a date in A1, B1 states
"1/1/1900", C1 states "1/2/1900"; but it works perfectly once I enter a date
in A1. I'm trying to create a timesheet template and don't want 1/1/1900 etc
to be confusing. Is there a way that until I have a date in A1, nothing will
show up in B1, C1, etc.? Thanks again. -Shannon

"Dave O" wrote:

In cell B1 your formula is
=A1+1

That will advance the date by one day. Copy that formula across, and
you're good to go.