Workday function combined with If function help

[ttanika]

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 75 day release

I need P8 to exclude weekends and holidays, so the 75 day release date will not include weekends and holidays. I tried to use the workday function. Can't figure it out. I have a list of the holidays on another sheet called Holidays.

 

[Rosen]

Do you mind listing the holidays you are using?

 

[Rosen]

Nevermind, the formula was bad, this should work:

=IF(L8<=0,"Eligible",IF(L8="a",WORKDAY(P8,29,Holidays),IF(L8="b",WORKDAY(P8,44,Holidays),IF(L8="c",WORKDAY(P8,59,Holidays)," "))))

 

[ttanika]

Nevermind, the formula was bad, this should work:

=IF(L8<=0,"Eligible",IF(L8="a",WORKDAY(P8,29,Holidays),IF(L8="b",WORKDAY(P8,44,Holidays),IF(L8="c",WORKDAY(P8,59,Holidays)," "))))

THANK YOU SO MUCH! It works GREAT! I really appreciate all of your assistance on this!!!!

 

[Rosen]

Your welcome, glad I could help.