Return the most recent date

G

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
 
Sort by date Sort by votes
golfgod said:
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
Click to expand...

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

=LOOKUP(9.99999999999999E+307,A:A)
 
Upvote 0
Aladin Akyurek said:
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.
Click to expand...
 
Upvote 0
golfgod said:
Aladin Akyurek said:
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.
Click to expand...

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,"")
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
A search formula (like index match) that can pull the most recent date when multiple matches may occur based on the criteria figure.
Replies
2
Views
339
MARZIOTULLIO
M
R
  • Solved
Adding Hours & Minutes to Dates & Times w/in Working Hours
2
Replies
11
Views
809
Asbestos_Jen
Asbestos_Jen
S
  • Solved
Separating text String with Name Date of birth and other information
2
Replies
12
Views
319
SeliM
S
N
  • Question Question
Auto Training Tracker w/MS Forms
Replies
6
Views
470
Snakehips
Snakehips
Z
  • Question Question
Countdown date
Replies
2
Views
139
Zatman
Z

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top