Check if a Date falls within a date range

		Microsoft Office Forums > Microsoft Excel > Excel
Check if a Date falls within a date range

FAQ

Thread Tools

Display Modes

02-02-2016, 02:05 PM

OTPM

Windows 7 32bit Check if a Date falls within a date range

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Check if a Date falls within a date range

Hi All

I am struggling with a formula to check if two dates fall within a date range.

Basically I have a week ending date in Cell D6.
I then want to check if either of the dates B8 and C8 fall within the range of "D6-6" and D6.
Any help with a formula would be appreciated.
Thanks in anticipation.
Tony

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter by a Month that falls within a date range	MattG1225	Excel	2	12-03-2015 07:44 AM
MS Project Date Range Issue	appelguy@gmail.com	Project	2	10-31-2015 11:52 AM
Formula for sumifs with less than a date range	lynchbro	Excel	6	04-15-2015 01:18 PM
HELP: Return a value with a date that falls between two other dates	hionman	Excel	5	11-12-2014 09:56 AM
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 02:13 AM.