Hi Stacey

I'm not fully understanding what you are saying.
Have you Inserted a Table?
If so, there is no question about having to copy formulae down, they get
added automatically as you add more rows to the table.
Sure, if they are looking up values from another sheet, and the values are
returned as dates, then the automatic filter button at the head of the table
column will still give the ability to sort by Date.

Can you describe in a little more detail what you problem is?
--
Regards
Roger Govier

"StaceyJ" wrote in message
...
Okay, so I finally figured out how to get my array to work. It's inputting
dates that it finds in cells on another tab (looking up based on criteria
and
returning all results in seperate cells).

Here is the problem. If I copy the array down only 10 rows, and I have the
filter on, it will still give me the ability to sort the output as dates
(which it should since they ARE dates). However, if I copy it down even 1
more cell, it changes the default sort to "A to Z" and will no longer let
me
sort them as dates. (Instead of giving me the sort options of "Oldest to
Newest" and "Newest to Oldest" it gives me "A to Z" and "Z to A". I'm am
using Excel 2007.)

I have to be able to sort them as dates. What should I do?