Aging Formula
 

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.

"bj" wrote:

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

To repeat what bj said: look for NETWORKDAYS in Excel's Help. It explains
limits and special features of the functions. For example - it may or may
not exclude holidays - but to do so, you have to tell it what the holidays
are in one of several fashions. Rather than cut and paste all of that info
into this post, I simply echo bj's recommendation.

"Steve" wrote:

does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.

"bj" wrote:

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

Thanks I fugured it out, another question, Could this same function be used
in msft access?

"JLatham" wrote:

To repeat what bj said: look for NETWORKDAYS in Excel's Help. It explains
limits and special features of the functions. For example - it may or may
not exclude holidays - but to do so, you have to tell it what the holidays
are in one of several fashions. Rather than cut and paste all of that info
into this post, I simply echo bj's recommendation.

"Steve" wrote:

does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.

"bj" wrote:

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

In Access you'd write a query to select records based on either the day of
the week or dates. You could have a table with holiday dates in it to assist
in the comparison.

"Steve" wrote:

Thanks I fugured it out, another question, Could this same function be used
in msft access?

"JLatham" wrote:

To repeat what bj said: look for NETWORKDAYS in Excel's Help. It explains
limits and special features of the functions. For example - it may or may
not exclude holidays - but to do so, you have to tell it what the holidays
are in one of several fashions. Rather than cut and paste all of that info
into this post, I simply echo bj's recommendation.

"Steve" wrote:

does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.

"bj" wrote:

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?

Aging Formula
 

I should add that there is a WEEKDAY function that can be a help in this -
but there is not a NETWORKDAYS function in Access. You can search Access's
Help for WEEKDAY to get a start in that direction - use the See Also link to
see other date related functions available in it.

"Steve" wrote:

Thanks I fugured it out, another question, Could this same function be used
in msft access?

"JLatham" wrote:

To repeat what bj said: look for NETWORKDAYS in Excel's Help. It explains
limits and special features of the functions. For example - it may or may
not exclude holidays - but to do so, you have to tell it what the holidays
are in one of several fashions. Rather than cut and paste all of that info
into this post, I simply echo bj's recommendation.

"Steve" wrote:

does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.

"bj" wrote:

check out Networkdays() in help

"Steve" wrote:

I have a column with a date and I have a column with an age (EXAMPLE: col (a)
7-5-07 and col (b) has 1), my question is how do I age using business day not
calendar days?