How to if statement for more than one cell ?

Mohammed Alolayan

How to if statement for more than one cell ?

What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell

Paul Newcome

Try something like this...

=IF(ISDATE([3rd Column]@row), [3rd Column]@row, IF(ISDATE([2nd Column]@row), [2nd Column]@row, IF(ISDATE([1st Column]@row), [1st Column]@row))) + n

Just replace n with however far out you want to go.

Paul Newcome

Try something like this...

=IF(ISDATE([3rd Column]@row), [3rd Column]@row, IF(ISDATE([2nd Column]@row), [2nd Column]@row, IF(ISDATE([1st Column]@row), [1st Column]@row))) + n

Just replace n with however far out you want to go.

Mohammed Alolayan

Dear Paul ,

Thank you for your reply,

I got an error message (#INVALID COLUMN VALUE)

Paul Newcome

The formula above would need to go into a date type column.

Mohammed Alolayan

It is all date type column

Paul Newcome

Are you able to provide a screenshot of the columns and the formula generating the error?

Mohammed Alolayan

Paul Newcome

And can you provide a screenshot of the column properties for the column that the formula is in?

Mohammed Alolayan

Paul Newcome

That's for Date 2 which is referenced in the formula. What about the column the formula is actually in?

Mohammed Alolayan

I got you

Now It is working perfectly

Thank you Paul

Paul Newcome

Great! Happy to help. 👍️