Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate the number of days from date received | Excel Worksheet Functions | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
Number of days since a date | New Users to Excel | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |