-
setting a date range
I'm trying to get a range of dates from one sheet to populate into another sheet. One sheet has dates written as example 02/05/05. In my source sheet I have one of two dates for every month either the 16 or the 31. written as 7/31/05. The date in my source because it is already exsisten defines the range that I need from my target. Example I need all rows with dates between 1/1/05-1/16/05. My question is, how do I set up an array with a selected set of dates?
Any help would be great. I may need to explain better to, but I'm not sure I know how.
Thanks
Nicole
-
Re: setting a date range
If you are storing the dates as dates (not text) you should be able to format them any way you like with the format cells (right click in the selected cells).
As to the filtering and showing, depends what you want to do with them. If it is display only, use the autofilter (it can take two arguements) with one set to 'greater than or equals' and the other set to 'less than or equals'.
If it is something more involved, please post up what you intend to do with the data you get.