| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Range for my time sheet
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Range for my time sheet
Where do you have =$L$4+1? If it's in L5 try this formula instead =IF(L4="","",IF(DAY(L4+1)DAY(L4),L4+1,"")) format as date and copy down column -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=516697 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Range for my time sheet
Thankyou daddylonglegs! that worked beaautifully!!
"daddylonglegs" wrote: Where do you have =$L$4+1? If it's in L5 try this formula instead =IF(L4="","",IF(DAY(L4+1)DAY(L4),L4+1,"")) format as date and copy down column -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=516697 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
