View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
amorx2 amorx2 is offline
external usenet poster
 
Posts: 2
Default 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.