mimimum of dates with if statement

[ramosca]

Hi Everyone

Having trouble putting the following statement together. I have various dates in column A and column B with some blanks mixed in.

I need a statement in column C that will show the earliest date between column A & B. If both columns are blank then I need a return of: "Still in Progress". Can anyone help?

Thanks!

 

[T. Valko]

Hi Everyone

Having trouble putting the following statement together. I have various dates in column A and column B with some blanks mixed in.

I need a statement in column C that will show the earliest date between column A & B. If both columns are blank then I need a return of: "Still in Progress". Can anyone help?

Thanks!

Are you wanting a result for each row?

What if there's only one date on the row?

Maybe this...

=IF(COUNT(A2:B2),MIN(A2:B2),"Still in Progress")

Format as Date

 

[ramosca]

It worked, thats exactly the formula i was looking for. Thanks!

 

[T. Valko]

It worked, thats exactly the formula i was looking for. Thanks!

You're welcome. Thanks for the feedback!