calendar question...

[bsurace]

i set up a calendar with business days listed with a number "1" in the
col to the right of the date. i am now trying to return business days
only to a list in another sheet.

i have done the following:

- did a vlookup to pull back dates referenced "JULY". i am trying to
search the calendar to pull bacl only the trading days. tried using
index, but have to change row number for every cell. also cannot
determine with index which dates to pull back...pulls theme all

i am looking for the following result:
7/5/2006
7/6/2006
7/7/2006
7/10/2006
7/11/2006
7/12/2006
7/13/2006
7/14/2006
7/17/2006
7/18/2006
7/19/2006
7/20/2006
7/21/2006
7/24/2006
7/25/2006
7/26/2006
7/27/2006
7/28/2006
7/31/2006

 

[João Araújo]

Hi bsurace!
I don't know if I understand what you want, but one possible solution is:

Create name for the cell that has 7/5/2006 as Day1, 7/6/2006 Day2 and so on.
On the other sheet simply put the formula = Day1, Day2 and so on.

HTH
Regards
João Araújo

 

[Maistrye]

i set up a calendar with business days listed with a number "1" in the
col to the right of the date. i am now trying to return business days
only to a list in another sheet.

i have done the following:

- did a vlookup to pull back dates referenced "JULY". i am trying to
search the calendar to pull bacl only the trading days. tried using
index, but have to change row number for every cell. also cannot
determine with index which dates to pull back...pulls theme all

i am looking for the following result:
7/5/2006
7/6/2006
7/7/2006
7/10/2006
7/11/2006
7/12/2006
7/13/2006
7/14/2006
7/17/2006
7/18/2006
7/19/2006
7/20/2006
7/21/2006
7/24/2006
7/25/2006
7/26/2006
7/27/2006
7/28/2006
7/31/2006

Make sure that both columns have headers, say Date (Column A) and
WorkDay (Column B).

Beside these two columns, put the following (this is the criteria for
the advanced filter):
C1: =B1 (The header for the WorkDay column)
C2: 1 (The value that we want to be selected)

Select A1:B50 (or however far down).

Use the Advanced Filter. (Data->Filter->Advanced Filter...)

Check the button beside Copy to another location

Make sure that List Range is the $A$1:$B$50 (or whatever)
Make the Criteria Range $C$1:$C$2
Make the Copy To Range whereever you want the data to go. (Say
$D$1:$E$50)

Hit OK.

This should put the list you want in the location you want.

Scott