Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a macro for date range.
I have a perpetual calendar in excel that updates each month by simply
changing the month and year to reflect most current month and year. For each month selected, formulas have been created to automatically insert 8hrs in a cell during weekdays only, but not including weekends. The timeframe captured is always the 1st-15th and sumed for total hrs and 16th-30th repeats the same process. Under the required cell with the 8hrs, I put the actual hrs worked for that day which is less than the required 8hrs or more. For the timeframe ending on the 15th of every month, I'm using this formula =IF((SUM(C$14-$B$3))<15,8,"") for the required 8hrs that automatically populates the cell. The days are fomatted Sun-Sat. I said all this to ask this question: 1) how do I create a formula that will add up my hrs manually inserted, only from the 1st-15th, and not capture remaining hrs on 16th, 17th etc. if on the same row of 15th? Please keep in mind I have a perpetual calendar 2) how do I create a macro button that will delete all data from 1st-15th timeframe, no matter what month I change the calendar to? 3) how do I setup my perpetual calendar to post the name of US holidays per month? The formula for the calendar days are =(WEEKDAY($B$3)=2)*B3+(B60)+B6 I don't know how to add the holiday to applicable day. Please help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating columns based on date range | Excel Worksheet Functions | |||
creating columns based on date range | Excel Programming | |||
Creating date range for x-axis label in Excel '07 | Excel Discussion (Misc queries) | |||
Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) | |||
Problem Creating a Date Range | Excel Programming |