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

AGrace

Board Regular
Joined
Jun 29, 2010
Messages
150
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
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
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
Joined
Jul 4, 2004
Messages
7,484
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
Joined
Jun 29, 2010
Messages
150
(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
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,665
Messages
5,833,013
Members
430,183
Latest member
Batbloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top