Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a timesheet/calendar in Excel
Assume the start date is in A1 and the end date is in A2
in A3 =A1 in A4 =IF(A3<($A$2),$A$1+ROW(A1),"") Then drag down the formula in A4 for the largest number of rows you would need to use. if you adjust the formula for different locations, Row(A1) should not be changed. -- Regards, Tom Ogilvy "Bob Edwards" wrote in message ... Is it possible to use Excel to create a timesheet/calendar? The pay period starts in one month and ends in the next month, eg Juloy 24 to Aug 23. I would like to input the start and end dates and have Excel generate the timesheet, adjusting for 28, 29, 30,or 31 days. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create own calendar using excel | Excel Discussion (Misc queries) | |||
How do I create a calendar from data in excel? | Charts and Charting in Excel | |||
Create a calendar in excel for the next 4 yeara | Excel Discussion (Misc queries) | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
how do i create a timesheet | Excel Worksheet Functions |