Return the most recent date

golfgod

New Member
Joined
Aug 16, 2015
Messages
5
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
 

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.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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
Joined
Aug 16, 2015
Messages
5
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.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201

ADVERTISEMENT

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,"")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,099
Messages
5,570,210
Members
412,309
Latest member
Benky
Top