jeudi 25 mai 2017

Excel Cell Value from 2 Cells

I have a query that feeds into Excel, with 2 different date columns. Either both columns will be blank or one of them will have a date value in it.

I want to determine if one cell has a value and put that value into a 3rd cell or leave it blank.

enter image description here

I keep attempting to put together AND, IF and ISBLANK statements and nothing has worked.

Any help is much appreciated.

Aucun commentaire:

Enregistrer un commentaire