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

#### AGrace

##### Board Regular
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.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### bobsan42

##### Well-known Member
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

##### Well-known Member
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

##### Board Regular
(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.

Last edited:

1,106,696
Messages
5,512,920
Members
408,921
Latest member
xfigo