Businessday (Networkday) Function

D

dannyboy213

Is there an equivalent formula for the NETWORKDAY function without
having to install the add-in "Analysis ToolPak"?
I am trying to create a function where it tells me day the last
businessday.
Example: Let's say today is Monday and the date is 1/30/06 and I want
on the next cell to figure out that the last business date was 1/27/06.
The problem is, I don't want to use the "Analysis Toolpak".
 
S

SteveG

If you consider a business day any weekday from Monday - Friday
regardless of holidays, I am pretty sure the WEEKDAY function is a
standard function. I came up with,

=IF(WEEKDAY(A1,2)=1,A1-3,IF(WEEKDAY(A1,2)=7,A1-2,A1-1))

Your date is in A1. This looks to see if the date is a Monday and if
so, subtracts 3 days from it, if a sunday, subtracts 2 days all other
subtract 1 day.

Does that help?

Steve
 
Top