Formula for Active In Current Month?

[Buffyslay]

hello all

i have a spreadsheet with contractors on.

I have a start date and an end date.

I want to be able to pull out the data from all those current in each
month (using the start date and the end date)

So - having complete braindead moment.... so any help would be great

Thanks
http://www.buffyslay.co.uk

 

[Peo Sjoblom]

The best way is probably to use either autofilter or advanced filter and
extract and copy somewhere else
Assume the contractors are in A2:A200 and the dates in B2:B200, apply the
autofilter and filter on B using
custom and greater than or equal to 10/01/03 AND less than or equal to
10/31/03, that will filter October 2003
Now you can just copy and paste the visible cells..