| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
