Excel 2007 question!!

ppteam

I have A1 to A9 holds 2009 holiday:

1/1/10
1/18/10
2/15/10
4/2/10
5/31/10
7/5/10
9/6/10
11/25/10
12/24/10

Now on A12 I manually type 09/01/2010, in A13 I use formula "=WORKDAY(A12, 1, A1:A9)", which gives me 1 working day beyond A12, exclude holidays in A1 to A9. This is correct.
Ok, then I copy A13 and paste to A14, I expect the formula in A14 as "=WORKDAY(A13, 1, A1:A9)", but excel gives me "=WORKDAY(A13, 1, A2:A10)", as see in the pic.

How to fix it, instead of editing the formula for every fxxking cell?

Thanks!

ppteam

should be 2010 holidays

源济

(1) 定义holiday:  Formulas => Define Name => holiday=Sheet1!$A$1:$A$9

(2) A13的公式改为：＝WORKDAY(A12, 1, holiday)

(3) 拷贝A13的公式到A14, A15, etc.，或者下拉A13的下边框，自动拷贝。

ppteam

回复 3# 源济

u the man!