S
sherry
My Dad has cancer and has to take many pills at different times of the
day, so to help him I have been making daily sheets. Each day he has a
new sheet that has the date at the top, followed by his pill schedule
for that day (Breakfast pills, Lunch pills, etc.) He crosses stuff off
as he takes it. I want a date on top because chemo complicates his
regiment and changes it, so it's not the same thing all the time and
important to know (and for him to know) which day it is. I also use
this as a log to keep track of his medical history -- another reason I
want each page dated.
I have been making these in Word for 4 years now, and it's extremely
time consuming to have to manually change the day of week and date at
the top of each sheet when I am preparing to print a new slew of them.
(Usually print a month's worth at a time.)
I have virtually no experience in Excel, but was hoping I could switch
to it, so that it would automatically fill in the date. I already know
how to insert the "long date" format (Day, Month, Year) into a cell,
but I don't know how to tell Excel to go to the next day every-so-many
lines down, and insert that.
In conjunction with this, how do I insert page breaks into the
document so I can see where each new page starts, so I know where
those dates belong??
Thanks so much for any help!
day, so to help him I have been making daily sheets. Each day he has a
new sheet that has the date at the top, followed by his pill schedule
for that day (Breakfast pills, Lunch pills, etc.) He crosses stuff off
as he takes it. I want a date on top because chemo complicates his
regiment and changes it, so it's not the same thing all the time and
important to know (and for him to know) which day it is. I also use
this as a log to keep track of his medical history -- another reason I
want each page dated.
I have been making these in Word for 4 years now, and it's extremely
time consuming to have to manually change the day of week and date at
the top of each sheet when I am preparing to print a new slew of them.
(Usually print a month's worth at a time.)
I have virtually no experience in Excel, but was hoping I could switch
to it, so that it would automatically fill in the date. I already know
how to insert the "long date" format (Day, Month, Year) into a cell,
but I don't know how to tell Excel to go to the next day every-so-many
lines down, and insert that.
In conjunction with this, how do I insert page breaks into the
document so I can see where each new page starts, so I know where
those dates belong??
Thanks so much for any help!