J
Jake
Hello All,
I have an project i'm working on to determine fiscal periods based on
date of invoice. I have one workbook ("FiscalPeriods.xls") that has the
date ranges for each fiscal period for the past three years. ie;
Period PeriodStartDate PeriodEndDate
1 1/1/2007 1/27/2007
2 1/28/2007 2/24/2007
3 2/25/2007 3/31/2007
4 4/1/2007 4/28/2007
The other workbook has about 30,000 records of invoices over the past 3
years that have a specific "InvoiceDate". What I want to do is take the
first record, analyze the date, and return a new column called "Period"
and the subsequent period number.
I just need any ideas on which direction I should go in. Any
suggestions are much appreciated.
Thanks,
JB
I have an project i'm working on to determine fiscal periods based on
date of invoice. I have one workbook ("FiscalPeriods.xls") that has the
date ranges for each fiscal period for the past three years. ie;
Period PeriodStartDate PeriodEndDate
1 1/1/2007 1/27/2007
2 1/28/2007 2/24/2007
3 2/25/2007 3/31/2007
4 4/1/2007 4/28/2007
The other workbook has about 30,000 records of invoices over the past 3
years that have a specific "InvoiceDate". What I want to do is take the
first record, analyze the date, and return a new column called "Period"
and the subsequent period number.
I just need any ideas on which direction I should go in. Any
suggestions are much appreciated.
Thanks,
JB