Mike's suggestion doesn't use the Analysis toolpak.

pano wrote:

Hmm cant use the analysis Toolpak addin, this is a work toughbook and
it is LOCKED down to billy oh by the IT Dept

On Jan 29, 9:22 pm, Mike wrote:
Fill in the first 2 days and then select your range including the 2 days you
typed and try Edit - Fill - Series - weekdays and this may do the trick.



"pano" wrote:
Hello all
I want to be able to put a date in cell a1 - 1st Jan 2007 and then
have a2 downwards automatically fill in the dates of the month
excluding the saturdays and sundays???

Any helpers with this

thanks- Hide quoted text -- Show quoted text -

--

Dave Peterson