What excel function do I use to display a date

oscarlimerick · #1 01-14-2021, 02:06 PM

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

macropod · #2 01-14-2021, 05:31 PM

=INDEX(A:A,MATCH(F3,B:B,0))
=INDEX(A:A,MATCH(F4,B:B,0))
Format the result as a date.

oscarlimerick · #3 01-14-2021, 07:17 PM

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