Sorry forgot to add that this will be used in mutiple cells in column U

"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