Nested if statements on Dates

Hi All-

I would like to have assistance in writing an equation which will look at several criteria and spit out if a date is between 2 given dates. Basically if it is in Batch 1 then the equation will check a date and see if it falls on our between 1/7/2013 - 1/18/2013 and returns true/false and if it is in batch 2 it does it for the corresponding dates etc.

Any thoughts on how to do this easily?

[TABLE="width: 210"]

[tr]

[td]

Batch

[/td]

[td]

Start Date

[/td]

[td]

End Date

[/td]

[/tr]

[tr]

[td]

1

[/td]

[TD="align: right"]2013-01-07[/TD]
[TD="align: right"]2013-01-18[/TD]

[/tr]

[tr]

[td]

2

[/td]

[TD="align: right"]2013-01-21[/TD]
[TD="align: right"]2013-02-01[/TD]

[/tr]

[tr]

[td]

3

[/td]

[TD="align: right"]2013-02-04[/TD]
[TD="align: right"]2013-02-15[/TD]

[/tr]

[tr]

[td]

4

[/td]

[TD="align: right"]2013-02-18[/TD]
[TD="align: right"]2013-03-01[/TD]

[/tr]

[tr]

[td]

5

[/td]

[TD="align: right"]2013-03-04[/TD]
[TD="align: right"]2013-03-15[/TD]

[/tr]

[tr]

[td]

6

[/td]

[TD="align: right"]2013-03-18[/TD]
[TD="align: right"]2013-03-29[/TD]

[/tr]

[/TABLE]

Re: Nested if statements on Dates

etaf-

Much thanks for your help! I appreciate you also including the file.