is answer right?

[bam12]

If e45 has 7/4/07 in it and a45 is 0 d45 has 0

holidays is a list of holidays and 7/4 is one in the list

I am thinking the answer should be 7/5 in the celll with formula in it.
But it is 7/4

which one is right?
[/quote]

 

[xld]

I tend to agree that it is odd, but it is difficult to know what to do when adding 0 and the nominated date is a holiday, next working day or previous?

Here is a solution along your lines of thought

=IF(G45="",WORKDAY(WORKDAY(E45,-1,holidays),A45+D45+1,holidays),
WORKDAY(WORKDAY(G45,-1,holidays),A45+D45+1,holidays))

 

[bam12]

problem

With the above mentioned example it not working right

if a45 has a3 in it and e45 had 9/3/07 in it then the date should be 9/6/07, but this formula is making it 9/7 which is wrong