Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
my payperiods run from the1st to the 15th and 16th to end of the month. i
currently have a time sheet displaying a start date: L4 and then each consecutive day as: $L$4+1 $L$4+2 and so on up to $L$4+15 (to cover all months) but in feb for example the dates populate into the next pay period. is there a better way to auto populate just the fields in the current pay period or to HIDE the rows that are outside the pay period? Thanks from the newbie!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Date Range and calculation | Excel Worksheet Functions | |||
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Discussion (Misc queries) |