Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date range within a date range
I have a start date and an end date. I want to determine if any of those
days in that range falls between two dates? Start Date of Project End Date of Project if any of those days falls between another start and end date, place an x in the field Start Date: 9/15/09 End Date : 10/1/09 from that date range, do any of the dates fall between 8/31/09 and 9/30/09 if so mark it with an "X" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date range within a date range
A little confusing. Please tell the story like this
A1 has start date of project B1 has end date of project ....... tell us where the X is to go best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "MoonBlosm" wrote in message ... I have a start date and an end date. I want to determine if any of those days in that range falls between two dates? Start Date of Project End Date of Project if any of those days falls between another start and end date, place an x in the field Start Date: 9/15/09 End Date : 10/1/09 from that date range, do any of the dates fall between 8/31/09 and 9/30/09 if so mark it with an "X" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date range within a date range
Assume the following:
Project start = B2 Project End = C2 Other period start = B3 other period end = C3 I see 2 possible scenarios that could lead to an "x"-reply 1) Either one or both of Project start and end fall between the "Other period" start and end 2) Project starts before "Other period" start and Project ends after "Other period" end. A formula for scenario 1 is =IF(OR(AND(B2=B3,B2<=C3),AND(C2=B3,C2<=C3)),"x", "") A formula for scenario 2 is =IF(OR(AND(B2=B3,B2<=C3),AND(C2=B3,C2<=C3),AND(B 2<B3,C2C3)),"x","") If this was helpful, please click Yes "MoonBlosm" wrote: I have a start date and an end date. I want to determine if any of those days in that range falls between two dates? Start Date of Project End Date of Project if any of those days falls between another start and end date, place an x in the field Start Date: 9/15/09 End Date : 10/1/09 from that date range, do any of the dates fall between 8/31/09 and 9/30/09 if so mark it with an "X" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |