Please Help With Daily Sheets!

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!
 
S

sherry

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??

Found this function. Still can't figure out how to make Excel
automatically sequence the date forward on each new page though...
 
S

sherry

OK. Figured it out. For anyone reading this in the future who needs to
know how to do this, you do it using the "fill" function:

1. Insert the initial date. To do this, highlight the cell where you
want the date, then from the "Home" toolbar's "Number" field (this is
a drop-down field in the center of the toolbar), click the arrow to
get a drop-down menu of items. Choose either Short Date or Long Date
as desired. A popup box will result, allowing you to fill in the day,
month and year. Click OK and the date will appear in the cell. Change
font/size (if needed) before copying the forumla.

2. Highlight the subsequent cells you need to carry the date formula
over to. This assumes the cells are not adjacent to the original cell
(if so, that's a different procedure). In this case the cells are
further down the page. So use CTRL+ click to highlight non-adjacent
cells, for example: cells A1, A40, A80, A120, etc.

3. From "Home" toolbar, click Fill (way over to the right), then
choose "Series" from the drop-down menu.

4. Click the radio button for Columns (or Rows if appropriate in your
case), and the Date and Day buttons should also be ticked. The "Step"
field will say "1" (to move one day forward in each new cell). Click
OK. The sequential date will be filled in the cells.

Note: only the first cell in the series can have a date filled in.
Subsequent cells must be empty for the fill function to work. If you
typed in (or copied) the original date into the subsequent cells, you
must first clear those cells before using the fill function.
 
S

sherry

Well, crud. Although the instructions I noted in the previous post
work, they still don't do what I want, as the formula doesn't "stick"
to the cells. That is, I want to be able to change the initial cell's
date (like next month) and have the effect ripple through the
subsequent cells without having to:

A. Clear the date from each cell from the previous month, then

B. Highlight the same 30 or 31 cells to re-apply the fill procedure.


What I'd like is for Excel to remember that cells "ZYX" look to cell
A1 for their data... that they read the DATE in A1 and apply their
formula automatically to display sequential dates.

Is this possible? Thanks.
 
S

Steve

Hi,

If the first date is in A1 enter the starting date in there.

If the second date is in A15 enter the formula =A1+1

If the third date is in A29 copy the formula in A15 and paste it into
A29 and into the subsequent date cells i.e. A43, A47, A71....... as
per my example.

Then when you change the date in A1 all the subsequent dates will
reflect the change.


Well, crud. Although the instructions I noted in the previous post
work, they still don't do what I want, as the formula doesn't "stick"
to the cells. That is, I want to be able to change the initial cell's
date (like next month) and have the effect ripple through the
subsequent cells without having to:

A. Clear the date from each cell from the previous month, then

B. Highlight the same 30 or 31 cells to re-apply the fill procedure.


What I'd like is for Excel to remember that cells "ZYX" look to cell
A1 for their data... that they read the DATE in A1 and apply their
formula automatically to display sequential dates.

Is this possible? Thanks.


--
Steve

A bank is a place that will lend you money if you can prove that you
don't need it.
- Bob Hope
 
S

sherry

Hi,

If the first date is in A1 enter the starting date in there.

If the second date is in A15 enter the formula =A1+1

If the third date is in A29 copy the formula in A15 and paste it into
A29 and into the subsequent date cells i.e. A43, A47, A71....... as
per my example.

Then when you change the date in A1 all the subsequent dates will
reflect the change.

A million thanks, Steve!!! Really appreciate it. :)
 
R

Roger Govier

Hi Sherry

You may not be following this thread now, but I have been out of the NG's
for a few weeks and only just spotted your posting.
I created a template for doing this sort of thing, which you can find at
http://www.contextures.com/Treatment Calendar.zip


--

Regards
Roger Govier

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!

__________ Information from ESET Smart Security, version of virus
signature database 5405 (20100828) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5405 (20100828) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5410 (20100830) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top