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.
|