Hello Bearacade:

I normally would have a field in a workbook where every single work day
would be incorporated into an adjoining cell. Every cell representing a
consecutive work day. So for a five day work week I would normally use the
function =WORKDAY(startdate,1,{holiday array}) and it would like
=WORKDAY(A1,1,$G$5:$G$20) and then I would drag and fill from column (A1) to
column (EE1) and have a date in every cell that excluded weekends and
holidays.

I hoping to find a formula that would do the same kind of autofill that
would only exclude Sunday and holidays. Any help is greatly appreciated, I
am beginner at best.

Thank you,


I am not sure what you are asking.. but try this..

I put 08/12/06 in A1, and put this in A2:

=IF(WEEKDAY(A1)=7, A1+2, A1+1)

Then I fill dragged down.

Make sure your format the cells into date


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570566