![]() |
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 |
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 |
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 |
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 |
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