#1
|
|||
|
|||
What excel function do I use to display a date
Please see attached excel. I have a spreadsheet that has a number of dates and values that correspond to those dates. I need to know the minimum and maximum values, which are calculated in cells F3 and F4, using =min(B:B), and max (B:B) but I also want to display the corresponding date, from column A, in cells H3 and H4. Is there a function or formula I can use to do this? Thanks |
#2
|
||||
|
||||
=INDEX(A:A,MATCH(F3,B:B,0))
=INDEX(A:A,MATCH(F4,B:B,0)) Format the result as a date.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Yes, that works perfectly, thank you so much
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using date function | lori2020 | Excel | 5 | 02-25-2020 12:47 PM |
Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
Using the sum function to display number as well as words in a single cell | officeboy09 | Excel | 8 | 10-30-2013 05:38 AM |
Excel date or edate function help | JohanB26 | Excel | 2 | 07-17-2013 09:23 AM |
Milestones: Display of - turning off the display of the date | Pmacdaddy | Project | 3 | 01-18-2013 05:42 PM |