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