Not sure what is going to be best

  • Thread starter dustinbrearton via OfficeKB.com
  • Start date
D

dustinbrearton via OfficeKB.com

I have a spreadsheet where each row represents a shipment. Each shipment has
shipment details in columns A:AP. I want cell AQ to contain the earliest
date from cells X, Z, AB, or AD. As an example for Row 2 I would like it to
look at X2, Z2, AB2, and AD2. Each of those cells will either be blank or
contain a date. If the cells have dates then I want it to return the cell
with the lowest date.

I started writing an IF statement to handle this but because of the
possibility of a blank cell the IF statement was a mile long and by the time
I finished writing it I did wasn't able to completely follow it. There must
be a better function or something that will do this.

Below is an example of data. I am only going to show the columns that I want
to measure

X2 | Z2 | AB | AD | AQ
5/9/08 | 4/5/08 | | 05/01/08 | 04/05/08
04/01/08 | 04/05/08 | 05/01/08 | | 04/01/08
06/06/08 | 06/01/08 | 06/02/08 | 05/30/08 | 05/30/08
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top