Peo,

You are the master! Thank you very much!

Monique

"Peo Sjoblom" wrote:

=WORKDAY(C1,1,Holidays)

copied across to N1 will increase a workday

in H2 you can use

=WORKDAY(N1,1,Holidays)

in I3

=WORKDAY(H2,1,Holidays)

and copy across

If you always put the first workday of the month in C1 you can use

=IF(ISTEXT(H2),"",IF(MONTH(WORKDAY(H2,1,Holidays)) <MONTH($C$1),"",WORKDAY(H2,1,Holidays)))

and copy across to R1



--


Regards,


Peo Sjoblom





"Monique" wrote in message
...
I want a function that fills in all the dates by filling one cell, and
since
I have to continue this on two rows, and I only want it to fill workdays
for
any given month minus holidays, this will not answer my question, but
thanks
anyway.