Is there a formula that can be created which tells you how old an item is only including weekdays (excluding weekends)? In other words, can Excel distinguish between weekdays and weekends?
Example: Let's say I have an entry dated 10/1/08. Is there a way to figure out how many weekdays there are between that day and today? I currenty use a formula similar to: =($J$1-A17) where $J$1 would be the current date and A17 is the date of the entry being aged. This formula includes weekends. I would only like weekdays.
Thank you
Jeff
Example: Let's say I have an entry dated 10/1/08. Is there a way to figure out how many weekdays there are between that day and today? I currenty use a formula similar to: =($J$1-A17) where $J$1 would be the current date and A17 is the date of the entry being aged. This formula includes weekends. I would only like weekdays.
Thank you
Jeff