View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Need task list that includes date and days + or -

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