Leaving a cell blank

  • Thread starter Thread starter Skip cell with dates
  • Start date Start date
S

Skip cell with dates

I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put
the date in (8/24/08) then use the control,+ and ; keys to drag the dates
across to the end or last cell. Now, How can I do this and skip one cell?
A1=8/24
A2=8/25
A3= skip the cell I want to leave it blank
A4= 8/26
A5=Etc
thanks,
Art
 
Is it just one cell that you want to leave blank or every third cell? If
every third cell then enter:

=IF(MOD(ROW(),3)=0,"",LOOKUP(10^10,$A$1:A1)+1)

In A2, format the cell as a Date then drag down on the fill handle.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Sandy,

It's only one cell.Starting with B1 and ending with G1. I would like to
leave D1 blank.
Have the dates skip over this cell.
Art
 
In C1 enter:

=IF(COLUMN(B1)=3,"",IF(COLUMN(B1)=4,A1+1,B1+1))

and copy across to G1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Shorter version:

=IF(COLUMN(B1)=3,"",MAX(A1:B1)+1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thanks so much! Works like a charm.
Art

Sandy Mann said:
In C1 enter:

=IF(COLUMN(B1)=3,"",IF(COLUMN(B1)=4,A1+1,B1+1))

and copy across to G1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Back
Top