What excel function do I use to display a date

		Microsoft Office Forums > Microsoft Excel > Excel
What excel function do I use to display a date

01-14-2021, 05:31 PM

macropod

Windows 10 What excel function do I use to display a date

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

=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]

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.