Here,

I've tried applying what you've suggested Bill and this is the formula
that I come up with which doesn't seem to want to work:

=OFFSET('[Jan 2008]Jan 2008'!D$13,DAY($C13),0)

In the Evaluate Formula the remark presented is:

"The cell currently being evaluated contains a constant."

I'm kind of learning this stuff on my own as I go along. So, you may
need to run through the procedure for doing this again for me to get
it.

If you have that much patients.

John

Johnz414;2572947 Wrote:
I'm sorry,

This is the time sheet template from Microsoft that I use:

http://tinyurl.com/yo6wbp

I've very easily augmented it for a month by extending-formatting the
time sheet from a week to a month and then I have 4 weekly time sheets
for the 4 weeks of the month after that in the same book, 6 pages
total.

So, my book starts with a cover page with the Business name and address
and mine too. Followed by the monthly work sheet (usually titled "Jan
2008" - "Month Year"). Followed by 4 weekly time sheets (titled "Week
1" etc.)

I also format my monthly sheets to start from the first day of each
month and include the entire month on each monthly sheet. I don't
follow a strict 4 week cycle.

For the weekly time sheets I just add the extra or minus days of the
month onto the last week of the 4 weeks. I then start on a new book.

The owner just wants to use it for a reference to see what I'm doing
and how he can advise me to cut corners.

But looking at the Microsoft template I think should show you
everything that you need for this. If not please let me know.

However, this template includes calculations for over time. I do not
need this, I don't get over time. In fact I don't remember a single
day of working more than 7 or 8 hours.

I have not so far tempered with the "Regular Hours" formula but I have
looked at it and see how I can take the over time out and simplify it.
If that will aid in getting what I'm after by all means please let me
know.

I have taken the "Over Time" column out and I changed the "Sick Time"
column to "Misc." - I get payed a fee for lock outs that I may include
here.

Everything else is just as is from the template.

Also, if possible I would like to automate everything, not only the
"Hours" and "Description" from the monthly to the weekly time sheets
but if I can also get it to carry over the formatting from when I first
put the day and date in on the monthly time sheet to have that
automatically carry over to the weekly time sheets that would save a
lot of time too.

Thanks,

John




--
Johnz414