The formula I have below in Column R works just fine. It creates a flag for
me (in Column R) that lets me know one of two things: €œClient Failed to
Enroll on Time€�, and €œReturn Referral Form to Referent€�. Here is that formula:

=IF(H4="","",IF(K4<"","",IF(S4="Sent","Client Failed to Enroll on
Time",IF(AND(K4="",TODAY()WORKDAY(H4,10,AA4:AA12) ),"Return Referral Form to
Referent",""))))

The one change (addition) that Id like to make, is this:

If Column N is toggled to say €œHudson Sat. & Sun.€�, than Id like the
following portion of the formula above to change:

TODAY()WORKDAY(H4,45,AA4:AA12))

Please note, that the only change in the string of formula above is the
reference to when the flag €œReturn Referral Form to Referent€� is triggered.
In the original formula, this flag triggers in 10 days (excluding holidays
and weekends) from the date of the referral (which we identify in column H).
If Column N is toggled to say €œHudson Sat. & Sun.€�, than I want to EXTEND the
length of time in which this flag would trigger (making it trigger at 45
days-as opposed to 10). The 45 days would continue to exclude weekends and
holidays as was true with the 10 day parameter.

Thanks in advance for any help!

Dan