workday function

Hello, In excel I am trying to return a date given a "start date", "excluding holidays", and "a number of days for completion". For example, given the start date of 9/1/2015, 60 days for completion, excluding holidays, would be XX/XX/XXXX. The "WORKDAY.INTL" function would be great, but I do...

I need to calculate a due date based on the number of days (including weekends); however, I need the due date to be on a workday. For example, if my project completion is due on December 1st I need to meet deadlines at various intervals prior to that. For simplicity let's have this sample...

I need the following formulas to report only weekdays. =IF(F2="","",IF(K2<"","Submitted",IF(F2>=TODAY(),EDATE(F2,0)-30,IF(F2<TODAY(),"Today","")))) =IF(F2="","",IF(G2="S",EDATE(F2,-2),IF(G2="R",EDATE(F2,-2),IF(G2="A","Not Needed",IF(H2="A","Bed Date...

Hello This forum has proved to be extremely useful for me. I have learnt a lot from this forum. I am looking for a function which can help me in finding which workday it is basis the date I mention. For example, in coloum A, I have several date mentioned for a particular month. I want to have...

Hello all I'm looking for assistance with Chip Pearson's Workday2 function, linked below; Better Workday Workday2 is a great alternate for Workday.INTL for those of us with Excel 2007. My only issue is Workday2 does not allow 'DaysRequired' to be a negative integer. Allowing a negative...

I have been working on this for a while and I can not figure it out. G8= Student entry date H8 = # of days in attendance I8 = =IF(H8<=30,P8-H8,"Ineligible") column I = the date students are eligible for 30 day release P8 = =IF(G8>=1,G8+75,"") column P = the date students are eligible for...