Left and If functions with a date range

[wagnered]

I want to be able to take the left 3 digits from the column B2 only if the date in A2 falls between the specified range. Otherwise I want it to display "-". I can't seem to wrap my mind around this today...HELP!

The formula found in C2 is:

=LEFT(IF(A2,">="&DATE(2011,10,1))-IF(A2,">"&DATE(2011,10,31))*B2,3)

Thanks in advance for help in this issue!

-EW

[Paul]

Hi EW, perhaps try:

=IF(AND(A2>=DATE(2011,10,1),A2<=DATE(2011,10,31)),LEFT(B2,3),"-")

Hope that helps!

[wagnered]

Nailed it! Thank you!

Re: Left and If functions with a date range

--------------------------------------------------------------------------------

Hi EW, perhaps try:

=IF(AND(A2>=DATE(2011,10,1),A2<=DATE(2011,10,31)),LEFT(B2,3),"-")

Hope that helps!
__________________
- Paul