Hi,
I am trying to find out a way to join a number of holiday ranges (defined names Rng1,Rng2,Rng3) lying in different columns into a single range and feed it to the WORKDAY function. however the WORKDAY function does not seem to work. used it as an Array, still not working.
{=WORKDAY(STARTDATE, NO_OF_DAYS, INDIRECT({"Rng1","Rng2","Rng3"}))}
i donot want to resort to VBA as its supposed to be submitted as an macro-free xlsx file.
This looks very challenging, so i would really appreciate it, if anyone with some bright ideas comes up with a definite solution on how to combine multiple holiday ranges into one single range or array of date values.
I am trying to find out a way to join a number of holiday ranges (defined names Rng1,Rng2,Rng3) lying in different columns into a single range and feed it to the WORKDAY function. however the WORKDAY function does not seem to work. used it as an Array, still not working.
{=WORKDAY(STARTDATE, NO_OF_DAYS, INDIRECT({"Rng1","Rng2","Rng3"}))}
i donot want to resort to VBA as its supposed to be submitted as an macro-free xlsx file.
This looks very challenging, so i would really appreciate it, if anyone with some bright ideas comes up with a definite solution on how to combine multiple holiday ranges into one single range or array of date values.