How to change date when printing several days attendance
 

In excel I am doing daily attendance sheets and need for the date and day to
ascend automatically. How can I accomplish this.

If the first date is in A1, you can simply put =A1+1 in cell B1. Adding 1 to
a date makes it the next day.
*******************
~Anne Troy

www.OfficeArticles.com


"Merlwyn" wrote in message
...
In excel I am doing daily attendance sheets and need for the date and day
to
ascend automatically. How can I accomplish this.

You don't even need that. Just put the first date in A1, and drag and copy
down, it will increment.

If you just want Mon-Fri, put the date in A1, then in A2 add

=A1+1+(WEEKDAY(A1,1)=6)*2

and drag and copy this down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anne Troy" wrote in message
...
If the first date is in A1, you can simply put =A1+1 in cell B1. Adding 1
to
a date makes it the next day.
*******************
~Anne Troy

www.OfficeArticles.com


"Merlwyn" wrote in message
...
In excel I am doing daily attendance sheets and need for the date and
day
to
ascend automatically. How can I accomplish this.