Put this is A1 if the month in question is May, month 5

=workday(DATE(YEAR(TODAY()),6,1),-4)

In A2, input

=workday(a1,1)

and copy down

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"SharonT" wrote in message
...
I need to be able to design a task list that automatically identifies the
last four weekdays of the month as Day - 4, Day - 3, Day -2, Day - 1 and
the
first four weekdays of the next month as Day +1, Day+2, Day+3, Day+4,
excluding weekends and holidays. For example,
cell A1 2/23/2007
cell A2 Day - 4
Cell B1 2/26/2007
Cell B2 Day - 3
Cell C1 2/27/2007
Cell C2 Day - 2
Cell D1 2/28/2007
Cell D2 Day - 1
Cell E1 3/1/2007
Cell E2 Day + 1, etc. The tasks would be listed in row three of each
column.
...
I would prefer having these cells calculate automatically by referencing
the
first day of the year. I think this is a calc using the functions
WEEKDAYS
and EOMONTH but can't get it to work. Maybe this is a VBA candidate.
--
Thanks, Sharon