Conditional WORKDAY function

[rizwanulhasan]

Hi,

In the attached image below, i want exact 1 day to be added to the date in cell C2 i.e. 24 hrs excluding the holidays mentioned in Sheet 1.

However, the time i receive in the cell D2 is always 12:00 AM whereas I want it to be 6:00 PM. i.e. date should change but the time remains as in the cell C2.

Can some one please guide with the correct formula.

Thanks in advance.

 

[Fluff]

You can add the time element back like

WORKDAY(C2,1,Sheet1!B3:B19)+MOD(C2,1)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Conditional WORKDAY formula
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.