Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2021, 02:06 PM
oscarlimerick oscarlimerick is offline What excel function do I use to display a date Windows 8 What excel function do I use to display a date Office 2013
Advanced Beginner
What excel function do I use to display a date
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default 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
Attached Files
File Type: xlsx SAMPLE FOR EXCEL.xlsx (9.5 KB, 5 views)
Reply With Quote
  #2  
Old 01-14-2021, 05:31 PM
macropod's Avatar
macropod macropod is offline What excel function do I use to display a date Windows 10 What excel function do I use to display a date Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

=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]
Reply With Quote
  #3  
Old 01-14-2021, 07:17 PM
oscarlimerick oscarlimerick is offline What excel function do I use to display a date Windows 8 What excel function do I use to display a date Office 2013
Advanced Beginner
What excel function do I use to display a date
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

Yes, that works perfectly, thank you so much
Reply With Quote
Reply

Thread Tools
Display Modes


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
What excel function do I use to display a date 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft