#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Have a go at the WORKDAY function using a negative number as second argument
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Formula for week days only
Perfect,
I used WEEKDAY(W3)-4 and worked!!! Thanks for you help. |
#4
|
||||
|
||||
Weekday ?????
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Formula for week days only
Sorry I meant:
I used WORKDAY(W3)-4 and worked!!! |
#6
|
|||
|
|||
This will not work as you have not entered the days!!
|
|
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 |