Autofill Date with =Today() function minus weekends.

[slkenda]

I am creating a type of planning/production schedule. I need to have a "moving" autofill of dates that removes weekends, but I also need to do this ever 4 lines. We can build 4 units a day.
Ex.
=Today() (9/20) 9/20, 9/20, 9/20, 9/23, 9/23, 9/23, 9/23, 9/24, 9/24,ect.

I can only get the weekdays to work if its only one line at a time. If I go every 4 lines, I cannot remove the weekends. Currently using Excel 2003

Thanks everyone.

[xladept]

Something like:

Please Login or Register  to view this content.

[Tony Valko]

Maybe this...

Data Range

	A	B
1	9/20/2013	Fri
2	9/20/2013	Fri
3	9/20/2013	Fri
4	9/20/2013	Fri
5	9/23/2013	Mon
6	9/23/2013	Mon
7	9/23/2013	Mon
8	9/23/2013	Mon
9	9/24/2013	Tue
10	9/24/2013	Tue
11	9/24/2013	Tue
12	9/24/2013	Tue
13	9/25/2013	Wed
14	9/25/2013	Wed
15	9/25/2013	Wed
16	9/25/2013	Wed

A1 = manually entered Monday thru Friday date

This formula entered in A2 and copied down as needed:

=WORKDAY(A$1,INT(ROWS(A$2:A2)/4))

Note that the WORKDAY function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the WORKDAY function. It'll tell you
how to fix the problem.

[SDCh]

May be like this:

Assume A1 = Today()
on A2

Please Login or Register  to view this content.

copy down A2 as long as you want

[Tony Valko]

Assume A1 = Today()
on A2

=IF(COUNTIF($A$1:A1,A1)<=3,A1,IF(TEXT(A1,"dddd")="Friday",A1+3,A1+1))

When A1 ( =TODAY() ) is a weekend date that formula returns the Sat, Sun dates for the first week.

[SDCh]

@Tony: Thanks, I'm forget if (=Today() = weekend)

I change the formula:

Please Login or Register  to view this content.