Day of month to Date in month
 

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.

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.

Day of month to Date in month
 

Thank you, Bob, but I'm sorry to say I'm not sure how to use this. Would you
mind plugging in an example, using the 4th working day?

Thanks, Bob.....


"Bob Phillips" wrote:

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