Aging Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
does this formula include or exclude the weekends? I need just mon - friday
and exclud the holidays.
 
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.
 
Thanks I fugured it out, another question, Could this same function be used
in msft access?
 
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.
 
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.
 
Back
Top