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.