workday and month functions
=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.
|