View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Dates for month in cell a1 downwards

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