Can I use some type of formula to age day by business days not calendar days?
And also exclude the NYSE holidays out?

Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
Without more information (your table structure) I can not show you how to
apply it.
--
KARL DEWEY
Build a little - Test a little


"Steve" wrote:

> Can I use some type of formula to age day by business days not calendar days?
> And also exclude the NYSE holidays out?

This formula gives me the number of week not business days.

"KARL DEWEY" wrote:

> Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
> Without more information (your table structure) I can not show you how to
> apply it.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Steve" wrote:
>
> > Can I use some type of formula to age day by business days not calendar days?
> > And also exclude the NYSE holidays out?

I thought that was what I said. I also said I needed more information on
your data to tell you how to apply it.
--
KARL DEWEY
Build a little - Test a little


"Steve" wrote:

> This formula gives me the number of week not business days.
>
> "KARL DEWEY" wrote:
>
> > Yes, you can use the Format([YourDateField],"w") to eliminate weekend days.
> > Without more information (your table structure) I can not show you how to
> > apply it.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "Steve" wrote:
> >
> > > Can I use some type of formula to age day by business days not calendar days?
> > > And also exclude the NYSE holidays out?

Check out http://www.mvps.org/access/datetime/date0012.htm at "The Access
Web", or my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access" (plus the related article in June, 2005). You
can download the columns (and sample databases) from
http://www.accessmvp.com/DJSteele/SmartAccess.html You will have to provide
the list of NYSE holidays, but hopefully the June, 2005 column will show you
how.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Steve" <(E-Mail Removed)> wrote in message
news:A19EC7D1-CF2C-48D2-94B0-(E-Mail Removed)...
> Can I use some type of formula to age day by business days not calendar
> days?
> And also exclude the NYSE holidays out?