If Cell equals text than take networkdays and add by a number

[sclasen24]

If Cell equals text than take networkdays and subtract by a number

If cell c = RD then take cell m (is a date 12/3) and add that by network days +18. This should tell me how many days to process this file.

[martindwilson]

use workday()
=if(c1="rd",workday(m1,18),"")

[sclasen24]

This is what I put in the cell, it returns ########

=IF(C2="RD",NETWORKDAYS(M2,18))

[martindwilson]

workday() not networkdays()
workday works like network days in that you can also add a range of holidays
but it returns the workday any number of days before or after the given date
http://office.microsoft.com/en-gb/ex...005209339.aspx
but if you want to know total days not date

then
IF(C2="RD",WORKDAY(C2,18)-C2,"") cell formatted general

[sclasen24]

If C2= RD & E1= P than N2= M1(setup date)+Networkdays+18(18 is equal to a variable I set, based upon what the program C2) days. Columns C could have different programs RD, FHA, CF, VA... which determines the variable above. Column E will include either P or R, Purchase or Refinance. If its an R it adds 3 more days.

RD= +28 days
FHA= +18 days
CF= +18 days
VA= +18 daysAttachment 285169
RD/DPAP= +60 days
FHA/DPAP= +60 days

[martindwilson]

what about fha/203k
these are your unique values in col c what are the days for each
RD
FHA
CF
FHA/203K
VA
FHADPAP
FHA/DPAP
Broker AFR
RD/DPAP

[sclasen24]

FHA/203k 60 days

[martindwilson]

so far then its
RD 28
FHA 18
CF 18
FHA/203K 60
VA 18
FHADPAP 60
FHA/DPAP 60
Broker AFR
RD/DPAP 60
what about the one in red

[martindwilson]

ok here is what ive got so far
you dont say what to do if m2 is blank
uses a lookup table on sheet1
attachment deleted at op request

[sclasen24]

If M2 is blank can we return a 0, You are a genius by the way

[martindwilson]

=IF(M2="",0,IFERROR(WORKDAY(M2,VLOOKUP(C2,Sheet1!$A$1:$B$20,2,FALSE)+IF(E2="r",3,0)),""))