View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Day of month to Date in month

=WORKDAY(DATE(2008,month_num,0),day_of_month)

--
__________________________________
HTH

Bob

"amorx2" wrote in message
...
Is there a way to populate a date each month based on a day of week
number?
We have monthly reports with due dates based on days of the month (for
reasons I won't get into here), and I'd like to find out what date those
days
fall on each month in order to plan resource time in advance. For example:
task 1 is due on the 4th working day each month. In March, the 4th working
day fell on March 6th; in April, the 4th working day fell on April 4th.

Thanks.