# Interval Dates

#### Meelkoppie

##### New Member
Please help me. I need a formula to show me if a specific date falls in interval dates 01.01.2009 and 30.04.2009. If it does it must show me "true" and if not "false". Eg 25.02.2009 = True

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### VoG

##### Legend
Try this

<b>Sheet24</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:75px;" /><col style="width:75px;" /><col style="width:75px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">01/01/2009</td><td style="text-align:right; ">30/04/2009</td><td style="text-align:right; ">25/02/2009</td><td style="text-align:right; ">TRUE</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >D1</td><td >=AND(C1>=A1,C1<=B1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

#### Meelkoppie

##### New Member
Hi VoG, Thank you very much for your fast reply. I appreciate it very much. The formula is just what I needed. Thanks again.

Replies
9
Views
210
Replies
3
Views
361
Replies
4
Views
185
Replies
0
Views
191
Replies
9
Views
291

1,190,841
Messages
5,983,187
Members
439,827
Latest member
JohnExcelHelp99

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back