|
|
#1
02-13-2014, 06:54 AM
|
|||
|
|||
Formula for week days only
I need a formula that will just subtract days from week days excluding any days on the week end.
Example: (weekdays only) I tried the formula below =IF(P3="s",WEEKDAY(W3-4)) P = S W4 = 2/24 Result should be 2/18 got 1/5/00 as a result. What am I missing? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Week by week report
|
thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
|
36 days task at 40% effort - only "0.86 days" in resource
|
hanvyj | Project | 9 | 07-09-2013 07:27 AM |
|
5 days/week during planning & 7 days/week during implementation
|
sanlen | Project | 1 | 06-25-2012 04:17 PM |
|
Formula to auto calculate Day of the week based on Date
|
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
|
How to reorder the days of the week
|
Mosey | Outlook | 2 | 10-31-2011 06:47 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode