Not sure what you're wanting but...

--
Biff
Microsoft Excel MVP


"Teethless mama" wrote in message
...
Your formula is including Sat, and Sun. OP doesn't want to include Sat,
and
Sun based on his/her formula


"T. Valko" wrote:

Not sure what you're wanting but...

A1 = 5/5/2008 (m/d/y)

Enter this formula in A2:

=DATE(YEAR(A$1),MONTH(A$1),DAY(A$1-1)+CEILING(ROWS(A$1:A2)/5,1))

When copied down, the formula will repeat each date 5 times then
increment
by 1 day:

A1 = 5/5/2008
A2 = 5/5/2008
A3 = 5/5/2008
A4 = 5/5/2008
A5 = 5/5/2008
A6 = 5/6/2008
A7 = 5/6/2008
A8 = 5/6/2008
A9 = 5/6/2008
A10 = 5/6/2008
A11 = 5/7/2008
etc


--
Biff
Microsoft Excel MVP


"Brooke" wrote in message
...
I have the following formula I created and was wondering instead of it
completing each consecutive weekday is there a way to have it take a
date
5-5-08 and use that same day every 5 lines then create the next weekday
add
that to 5 lines and continue down 1700 records???

=IF(WEEKDAY(K2)=7,K2+2,IF(WEEKDAY(K2)=6,K2+3,K2+1) ) - Where cell K2 is
the
start date.

I have a 1700 record spreadsheet that instead of keying a date myself
every
5 records having a formula do it for me.

Please Help.