mimimum of dates with if statement

ramosca

New Member
Joined
Mar 5, 2012
Messages
17
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!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,841
Messages
5,525,166
Members
409,629
Latest member
McGuilliam

This Week's Hot Topics

Top