Posted by matthew schmitt on May 09, 2001 9:55 AM
I am trying to create a macro which will determine the current age in days(not including weekends and certain holidays)of an item, based on the date when the item was entered on to the sheet. I can do it with a formula, but due to protection issues, it will work better with a macro button that updates the age. Unfortuneately, I am not sure how to code this, and I can't find any examples in any books. Any help would be appreciated.