I'm trying to build schedules in Excel with anywhere between 10 and 30
scheduled tasks within the timeline of a few months. The formulas I need to
use seem like they would be pretty basic, but I realize I need some task
dates based on calendar days and some on business days. For example, I need
to allow a calendar week for people to provide comments, but then need to
print the document 2 business days later. So how do I distinguish between
counting calendar days and counting only business days? I've searched the
help options in Excel and nothing I've found seems to speak to this
particular issue. I'm also pretty new to working in Excel, so there might be
an obvious solution out there that I just don't know about.
Thanks!
Maureen