Getting Unexpected Results using AND function

[JAlbers]

Greetings all.

I have a column of dates in a table that I am wanting to make selections from. My selection I think is relatively straight forward and none to complex (or I wouldn't have come up with it) =AND($A4>= BegDate,$A4<=EndDate) This is returning FALSE even when A4 is clearing between the beginning and ending dates.

I have tried writing the formula manually using the actual dates and get the same response "FALSE". I must be missing something but I do not see what it is.

Any help would be greatly appreciated!

Thanks

Jake

 

[Gary's Student]

You formula (modified)

=AND($A4>= DATE(2012,1,1),$A4<=DATE(2012,12,31))

seems to work if A4 contains =TODAY()

Check your data as the formula looks good.

 

[shg]

All all of those values Excel serial dates (i.e., do they appear as numbers when formatted as General)?

Is BegDate <= EndDate?

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/660464-getting-unexpected-results-using-function.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).

 

[Joe4]

Sorry Peter, looks like you were locking the thread just as I was merging the two. I have merged them, and re-opened the single, combined thread.

 

[JAlbers]

Yes, the numbers are all numeric when formatted as General. And Endate is calculated as BegDate + 6.

 

[JAlbers]

Sorry, I think I double clicked post instead of single clicking.

 

[shawnhet]

Not sure if it is this simple but the formula you copied in above has a space before Begdate.

Cheers,

 

[JAlbers]

You formula (modified)

=AND($A4>= DATE(2012,1,1),$A4<=DATE(2012,12,31))

seems to work if A4 contains =TODAY()


Check your data as the formula looks good.

I'm not sure how to get the dates formatted this way when using the date input into VBA which are stored as my variables BegDate & EndDate

 

[JAlbers]

Not sure if it is this simple but the formula you copied in above has a space before Begdate.

Cheers,

Sorry, it just crawled in when I was writing the post. There are no spaces in the worksheet.