Find a Date in a Range

		Microsoft Office Forums > Microsoft Excel > Excel
Find a Date in a Range

02-15-2016, 08:37 AM

rspiet

Windows 7 64bit Find a Date in a Range

Office 2010 32bit

Novice

Join Date: Nov 2014

Posts: 12

Your formula did not work for me, but I got the following formula to work.

=LOOKUP(2,1/((E2>=$A$2:$A$13)*(E2<=$B$2:$B$13)),$D$2:$D$13)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check if a Date falls within a date range	OTPM	Excel	7	02-03-2016 09:11 PM
MS Project Date Range Issue	appelguy@gmail.com	Project	2	10-31-2015 11:52 AM
find IP in range / find number between numbers	gn28	Excel	4	06-14-2015 03:46 PM
Restrict Date Range Calculations	akatz85	Excel	4	03-27-2014 08:46 PM
Date Range Prompt	MikeWooZ	Excel	6	12-04-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 AM.