Added value to cell

B

bbc1

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
 
D

Dave Peterson

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

Format the cell as a date.


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
Click to expand...
 
B

bbc1

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