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.