| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Match Month in Date With Month in Header | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
Linear Mode
