Date ranges

[Ed in Aus]

Just trying to get a function or some vba code to find out if 2 dates cover a certain date (7-9-2007) glad to give more information if you need it.

Thanks guys

 

[Peter_SSs]

Just trying to get a function or some vba code to find out if 2 dates cover a certain date (7-9-2007) glad to give more information if you need it.

Thanks guys

Like this?

Excel Workbook
	A	B	C	D	E
1	First Date	Second Date		Date of Interest	Covered?
2	15/07/2007	25/07/2007		01/08/2007	No
3	15/05/2006	18/12/2007		21/11/2006	Yes
Date Cover

 

[Ed in Aus]

Hi Peter thanks for your reply I will keep this one in mind for the future, I ended up using auto filter for both coulmns row is greater than date of interest -1 and row 2 is less than date of interest +1, but your formula looks neat

thanks again

 

[Ed in Aus]

another question, can this be a user defined funtion?