# Return the most recent date

#### golfgod

##### New Member
I am working with a range of dates that tasks were completed. However some of the cells are blank because the tasks are in process. I need a formula to return the most recent date indicated in the rage once all of the cells in the range have completed dates by them.

GG

### Excel Facts

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

#### 123rickfear

=max

##### MrExcel MVP
I am working with a range of dates that tasks were completed. However some of the cells are blank because the tasks are in process. I need a formula to return the most recent date indicated in the rage once all of the cells in the range have completed dates by them.

GG

I the most recent means the last entered date...

=LOOKUP(9.99999999999999E+307,A:A)

#### golfgod

##### New Member
I the most recent means the last entered date...

=LOOKUP(9.99999999999999E+307,A:A)

The result was not what I was seeking. I don't think I initially provided enough data.

I am working in the range I6:I15. The formula is in cell I5. I6 has a date in it but I7:I15 do not and are blank. I would like my formula cell to remain blank until cells I6:I15 have dates in them. At that time I would like the formula in cell I5 to return the most recent date in cells I6:I15.

##### MrExcel MVP

I the most recent means the last entered date...

=LOOKUP(9.99999999999999E+307,A:A)

The result was not what I was seeking. I don't think I initially provided enough data.

I am working in the range I6:I15. The formula is in cell I5. I6 has a date in it but I7:I15 do not and are blank. I would like my formula cell to remain blank until cells I6:I15 have dates in them. At that time I would like the formula in cell I5 to return the most recent date in cells I6:I15.

If I15 is supposed to house the most recent date...

=IF(ISNUMBER(I15),I15,"")

Note that this assumes an entry in I15 if and only if the cells above are already filled up.

Otherwise, whichever of the following is appropriate:

=IF(COUNT(I6:I15)=ROWS(I6:I15),MAX(I6:I15),"")

=IF(COUNT(I6:I15)=ROWS(I6:I15),I15,"")

#### golfgod

##### New Member
Thank you. =IF(COUNT(I6:I15)=ROWS(I6:I15),MAX(I6:I15),"") worked.

##### MrExcel MVP
Thank you. =IF(COUNT(I6:I15)=ROWS(I6:I15),MAX(I6:I15),"") worked.

You are welcome.

Replies
1
Views
190
Replies
2
Views
63
Replies
8
Views
96
Replies
2
Views
151
Replies
18
Views
229