ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Businessday (Networkday) Function (https://www.excelbanter.com/excel-discussion-misc-queries/68791-businessday-networkday-function.html)

dannyboy213

Businessday (Networkday) Function
 

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".


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507351


Bob Phillips

Businessday (Networkday) Function
 
=A1-1-(WEEKDAY(A1)=2)*2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dannyboy213"
wrote in message
...

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".


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile:

http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507351




SteveG

Businessday (Networkday) Function
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=507351


dannyboy213

Businessday (Networkday) Function
 

It works! Thank you very Much Bob.


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507351


Bob Phillips

Businessday (Networkday) Function
 
It's a pleasure.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dannyboy213"
wrote in message
...

It works! Thank you very Much Bob.


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile:

http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507351





All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com