Microsoft Office Forums Check if a Date falls within a date range
 Register FAQ Search Today's Posts Mark Forums Read

#1
02-02-2016, 02:05 PM
 OTPM Windows 7 32bit 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
#2
02-02-2016, 10:50 PM
 xor Windows 10 Office 2013 Expert Join Date: Oct 2015 Posts: 1,041

=b8=median(b8,d6,d6-6)
=c8=median(c8,d6,d6-6)
#3
02-03-2016, 01:55 AM
 OTPM Windows 7 32bit Office 2010 32bit Expert Join Date: Apr 2011 Location: West Midlands Posts: 981

Hi Xor
Many thanks for your prompt response. Apologies for not making my request clearer. Across the top of my worksheet I have a series of week ending dates (row 6). Where a date in col B or C falls within each of these weekending dates I want to populate that cell with a "0" where I will use conditional formatting to colour each cell that matches.
A sample worksheet is attached for clarity.
Tony
Attached Files
 Sample Excel Gantt Chart.xlsx (18.2 KB, 5 views)
#4
02-03-2016, 02:23 AM
 xor Windows 10 Office 2013 Expert Join Date: Oct 2015 Posts: 1,041

Could you please in your file state exactly the results you want returned in D7, E7, F7 ... and D8, E8, F8 etc.

It would help if you give some more examples.
#5
02-03-2016, 03:07 AM
 OTPM Windows 7 32bit Office 2010 32bit Expert Join Date: Apr 2011 Location: West Midlands Posts: 981

Hi Xor

Thanks

Tony
Attached Files
 Copy of Sample Excel Gantt Chart.xlsx (18.6 KB, 4 views)
#6
02-03-2016, 03:48 AM
 xor Windows 10 Office 2013 Expert Join Date: Oct 2015 Posts: 1,041

Sorry but I have no solution.
#7
02-03-2016, 04:22 AM
 OTPM Windows 7 32bit Office 2010 32bit Expert Join Date: Apr 2011 Location: West Midlands Posts: 981

Hi Xor
Many thanks for Trying.
Tony
#8
02-03-2016, 09:11 PM
 mikec Windows XP Office 2010 32bit Advanced Beginner Join Date: Nov 2012 Posts: 30
dates in a range

I'm not sure I have fully understood your problem but have a look at Book1.xlsx attached
Attached Files
 Book1.xlsx (9.5 KB, 3 views)

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post MattG1225 Excel 2 12-03-2015 07:44 AM appelguy@gmail.com Project 2 10-31-2015 11:52 AM lynchbro Excel 6 04-15-2015 01:18 PM hionman Excel 5 11-12-2014 09:56 AM MikeWooZ Excel 6 12-04-2011 02:10 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:33 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top