Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide month into two payroll periods
I am trying to display rows by pay period. The dates would be from the 1st to
the 15th or 16th to the end of the month. I am using a calendar control to select the start date. The calendar control inserts the pay period start date into A11. Then A12 is =(A11+1)*(MONTH(A11+1)=MONTH($A$11)) A13 is =(A12+1)*(MONTH(A12+1)=MONTH($A$11)) and so on. If I select the 16th for the start, it correctly shows rows for the 16th to the month end except for numerous blank rows after the last date. But if I select the first pay period, the entire month displays. What I am trying to accomplish is to display only the neccessary rows for the pay period, whether it starts on the 1st or 16th, without extra dates or blank rows. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the number of month between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of month between 2 periods? | Excel Worksheet Functions | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
working out quarters (three-month periods) between two dates | Excel Worksheet Functions |