View Single Post
  #4   Report Post  
bbc1
 
Posts: n/a
Default Added value to cell

Thankyou, I had a formula for the one instance but couldnt work out the other
cells, once again thankyou

"Dave Peterson" wrote:

=if(u4="","",u4+1)

Format the cell as a date.



bbc1 wrote:

Cell u4 has a set date in it I would like cell u8 to register this date plus
1 but if cell u4 is blank then u8 is to be blank.
ie U4 = 20/10/05
U8 = 21/10/05
if U4 blank
U8 is blank


--

Dave Peterson