excel function for sorting by month

[pboost1]

I am having a little problem. I have a workbook at work and we need t
know who is coming due for the following month. We want a worksheet t
list seperately those that are coming due to avoid confusion. Thos
that have access to this workbook do not know excel that well.

example:

sheet one contains customer numbers in column A and there due date i
column H. we need column D of worksheet 3 to list those that ar
coming due.

Any help with this would be appreciated

 

[Frank Kabel]

Hi
why not use 'Data - Filter' for this. e.g. an advance filter to create
a separate list of your due recors.

Note: This is NOT dynamic of course

 

[pboost1]

thanks, but I am not that familiar with the filtering of data. I am no
sure what to do? I did see the DGET function, but couldn't seem to ge
that to work either. my guess is I would need a "do/loop" or a
"if/then" statement but not sure how to write the function.

Again, thanks for any help that may be available