How to change date when printing several days attendance

M

Merlwyn

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

Bob Phillips

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)
 
Top