I need help - Excel formula to autofill a cell with a date +1, but displaying a blank if source is blank

[AGrace]

Hi all,

I've got a worksheet that has a cell in D3 that a user adds a date to. Further down the worksheet, the first cell of a table is populated by the date entered by the user using this formula:

=IF(ISBLANK(D3),"",D3)

Below this cell is a series of cells I want to populate using the date in the above cell (C148) adding 1 to the date (ergo; =C148+1) but only when there's a value, otherwise I'd like it to display a blank.

I tried this: =if(ISBLANK(C148),"", C148+1) but it doesn't work... I'm rubbish at formula's and can seem to find specific help on this online.

any help is appreciated!.

Thanks.

Adam

 

[bobsan42]

if cell C148 contains this : =IF(ISBLANK(D3),"",D3)

then put in the other one: =if(C148="","", C148+1)
because C148 has a formula in it so it is not blank (it is either a date or a zero-lenght string "", but is NOT blank)

 

[jim may]

YOur formula works for me if C148 has either a date or is blank.
A " " (space bar entry) creates a #VALUE! - What's in your cell C148?

 

[AGrace]

(SOLVED) Re: I need help - Excel formula to autofill a cell with a date +1, but displaying a blank if source is blank

if cell C148 contains this : =IF(ISBLANK(D3),"",D3)

then put in the other one: =if(C148="","", C148+1)
because C148 has a formula in it so it is not blank (it is either a date or a zero-lenght string "", but is NOT blank)

Thanks bobsan42, that worked perfectly!

Thanks for looking into it too Jim.

Adam