View Single Post
  #3   Report Post  
Shannon
 
Posts: n/a
Default

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.