LinkBack URL
About LinkBacks
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.
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.
use workday()
=if(c1="rd",workday(m1,18),"")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This is what I put in the cell, it returns ########
=IF(C2="RD",NETWORKDAYS(M2,18))
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
Last edited by martindwilson; 12-19-2013 at 11:20 AM.
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
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
Last edited by martindwilson; 12-19-2013 at 03:15 PM.
FHA/203k 60 days
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
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
Last edited by martindwilson; 12-19-2013 at 07:31 PM.
If M2 is blank can we return a 0, You are a genius by the way
=IF(M2="",0,IFERROR(WORKDAY(M2,VLOOKUP(C2,Sheet1!$A$1:$B$20,2,FALSE)+IF(E2="r",3,0)),""))
Last edited by martindwilson; 12-19-2013 at 07:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks