Have a look at the WORKDAY function...
...where A2 contains your starting date.
Hope this helps!
Hello, I need a excel formula or an excel vb formula to find the business day previous to today. For example if today was a monday Feb 14th I would need the formula to return Friday Feb 9th or 2/2/2007 not Sunday Feb 13th. Does anyone know of a way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)