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
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