Question Need a idea for a date field, for due dates

[Joe8915]

I have a form for Due dates based on a date received. Real simple:
Field is reads:
=Date()+5
If it lands on a Friday, I need to add 2 more days
If it lands on a Holiday add 1 more day
Have not figure out if a Holiday lands on a Friday, then I have to add 3 more days.

I was messing around with a conditional format, maybe using a Long date format
Any Ideas

 

[Brianwarnock]

Friday is easily cateredfor using the weekday function, but holidays are more complex , however this has been asked and answered many times so a search of the forum, perhaps using google as explained on a sticky in General i think would prove fruitful.

Brian

 

[Joe8915]

You are right Brian, I should have look more through the form