Display workday dates only

[Heath]

I am trying to create a function that only displays workday dates (ommits
weekend dates) when I fill across the sheet. This is what I have so far, any
suggestions? Thank you as always.

9/22/2004 9/23/2004 9/24/2004 9/25/2004 9/26/2004 9/27/2004 9/28/2004

3 4 5 6 7 1 2

9/22/2004 9/23/2004 9/24/2004 9/27/2004 9/28/2004
or
9/22/2004 9/23/2004 9/24/2004 9/27/2004 9/28/2004 9/27/2004
**********Functions associated with each row*************
38252 38253 38254 38255 38256.... date serial numbers for above

=WEEKDAY(E8,2)=WEEKDAY(F8,2)=WEEKDAY(G8,2)....function for day numbers

=IF(E13>5,"",E8)=IF(F13>5,"",F8)=IF(G13>5,"",G8)...one of my possible
functions

=IF(E17="",G17,E17) =IF(F17="",H17,F17) =IF(G17="",I17,G17)...second possible

but niether one obviously works.

 

[JulieD]

Hi Heath

enter your first date, select that cell & select the columns to fill across
to
choose edit / fill / series
click weekday
click OK

 

[Heath]

Yes, I have tried this and it still displays the weekend dates. What I would
like to display, for example is: 9/17/04 9/20/04 9/21/04... cosecutive
workdays with no gaps where the weekends would go. Thank you.

 

[Heath]

I finally figured it out I am so sorry to waste everyones time thank you so
much for your patience.

 

[Frank Kabel]

Hi
also have a look at the
WORKDAY
function