ExcelBanter - Added value to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Added value to cell (https://www.excelbanter.com/excel-discussion-misc-queries/51729-added-value-cell.html)

bbc1

Added value to cell

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

bbc1

Added value to cell

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

Dave Peterson

Added value to cell

=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

bbc1

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

All times are GMT +1. The time now is 10:56 AM.