Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
month calendar
Our boss asked us to fill a report every month where we set the time on
different projects (for billing purpose). He gave us a template where they are lines with the projects and columns with days. When a day is on the weekend, he must have grey background and no calculation (time total). As you can guess, the weekends changes every month, so every user copy the existing previous month, and takes 15 minutes changing the report, removing existing weekends and placing new ones. Would it be possible, by setting the name of the sheet (say 1/2003) to automatically fill this report to match the weekends of january 2003 ???? I'm new on Excel programming (I'm a Delphi programmer), so any code would greately be appreciated. Thanks in advance. BoB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Wednesdays within a calendar month | Excel Worksheet Functions | |||
=month() function equivalent for fiscal calendar | Excel Worksheet Functions | |||
Calendar 1st month ok but 2nd to 12th how. | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
Sm Product a Calendar Month Range? | Excel Worksheet Functions |