Formula for week days only

		Microsoft Office Forums > Microsoft Excel > Excel
Formula for week days only

FAQ

Thread Tools

Display Modes

02-13-2014, 06:54 AM

gbaker

Windows 7 32bit Formula for week days only

Office 2010 32bit

Competent Performer

Join Date: May 2012

Posts: 111

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:43 AM.