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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > In excel I am doing daily attendance sheets and need for the date and
day
> to
> > ascend automatically. How can I accomplish this.
>
>