Hello
I did everything exactly how you told me to do at least to the best of my
knowledge and nothing in the A column changed when I drag/copy, it just
starts with Thursday and then Tuesday. The date only changes on the first 3
days and the D12 spot doesn't change.
I guess I should just go back to changing the dates one at a time and save
myself the frustration. Obvilusly what should be a simple fix just isn't
co-operating with me.
Thanks
"Gord Dibben" wrote:
Select A15 and type in Thursday.
Drag/copy that down to A28
Select D11 and change the date to 7/12/2007
Don't touch D12...........it will update with D11
Note the dates in B15:B28 will change for the 14-day period.
Gord
On Wed, 11 Jul 2007 19:40:01 -0700, cainart
wrote:
Hello
I got the be-weekly template from
http://office.microsoft.com/en-ca/te...CT101172771033
Version: Excel 2000 or later
Download size: 20 KB (<1 min @ 56 Kbps)
I hope this helps you to help me and I will try what you already suggested
as well.
Thanks
"Gord Dibben" wrote:
Post the URL where I can download your Template and see what's up.
Should be an easy fix.
Gord
On Wed, 11 Jul 2007 16:40:01 -0700, cainart
wrote:
Hi again
I did what you said and it isn't working, however I was wondering if I need
to something didfferent since the start of the 2wk period is put into D12 and
the end of the 2wk period is put into D13. Could you try to help me one more
time?
Thank you
"cainart" wrote:
Hello
I think I need a little more information, thank you. It looks like you want
me to put in this case it is A15 for the start date and instead of Thursday
you want me to put in A14+1 and copy down (not sure what you mean). Please
understand I have never formatted anything before so I need detailed info to
accomplish this. It sounds like you can help if you have the patience.
I look forward to your response, thank you.
cainart
"Roger Govier" wrote:
Hi
Starting with the cell representing the first day - let's assume this is
cell A5, enter
=A1 where A1 represents the cell location where you have entered start
date.
In A6 enter =
A5+1 and copy down.
Format the cells, FormatCellNumberCustom dddd
--
Regards
Roger Govier
"cainart" wrote in message
...
I downloaded a Bi-weekly timesheet for Excel. The timesheet is perfect
except for the date part. The time sheet comes with a Monday to
Friday
bi-weekly time set-up and I need to change it to a Thursday to
Wednesday
bi-weekly time set-up. At present I had to individually change the
days
starting with the Thursday and when I change the start date and ending
dates
the only days that automatically change are the first Thursday to
Sunday
settings (4 days). How do I set it up so that all days change when I
put the
start date and end date at the top of the sheet?