JOINING FUNCTIONS

[DH]

Ihave two Functions 1.AddWeekdays.....this has a dates issued & a total number of days.This gives a projected date.

2.Holidays...taken from Microsoft support....removes holidays within certain dates.

Is it possible to insert the holidays function into Addweekdays.At present I have to keep creating further expressions to stop the date falling on a holiday.

Thanks for any help

David

 

[A real begineer]

From your question it appears you have a code that goes something like:

x+y = addWeekdays

if this is the case then I think this would fix the problem

if (addWeekdays=Holidays) then
txtW=addweekdays +1
elseif (addWeekdays<>Holidays)then
txtZ=addWeekdays
end if

strA=txtW,txtZ

 

[DH]

Here come the dumb questions.

Is this new code added into one of my two current functions or as a new one or somewhere else.

Thankyou

David