Thread: Formula for week days only
View Single Post
 
Old 02-13-2014, 06:54 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
  
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default 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?
Reply With Quote