| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to provide week commencing and part week commencing d
I need a macro that will populate columns with W/C dates and the dates of any
part weeks where the end of the month falls within a certain week. E.g. If Cell A1 has the date 02/01/06, I'd like cell B1 to show 09/01/06 and so on until the end of the year. However where the end of the month falls within Monday - Friday I need the week commencing date prior to the end of the month to be shown, such as 30/01/06 and then the next column to show 01/02/06. The next column would then start again to show week commencing dates. And so on and so on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| Calculate Week commencing | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
