If statement using dates.

Hi Everyone, I am sorry if this topic has been discussed before. I looked through a couple of threads, but could not see anything for my needs.

I have Five columns, The first four columns contains dates for the last document received per document.

Now in the 5 column, I would like to add an If statement that will automatically pull in the latest date of the four columns in that row.

Please advise if anyone can assist or if more info is needed.

Looking forward to your answers.

Originally Posted by TMS

You don't need an IF statement.

A date is simply a number ... the number of days starting at 01/01/1900. Therefore, you can just use MAX.

Formula:

Please Login or Register  to view this content.

Regards, TMS

Thank you!

I presume then, that there can only be dates or numbers in the data, otherwise the results will be effected?

Originally Posted by TMS

You said

It will ignore empty cells, spaces or alphabetic characters. If you put in a number other than a date, yes, it may affect the result.

A date in the year 2014 will be greater than or equal to 41640. So, if you were to put in a number like 999, it probably wouldn't make a difference. On the other hand, if you were to put a number like 99999, you would get a date value = 13/10/2173.

Regards, TMS

Thank you, It worked perfectly.

Is it possible when doing thing, that it also take the cells format (specifically the colour of the cell)?