Aging bu business days not calendar days

[Steve]

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

 

[KARL DEWEY]

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.

 

[Steve]

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

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

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

 

[KARL DEWEY]

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

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

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

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

 

[Douglas J. Steele]

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.