View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
cainart cainart is offline
external usenet poster
 
Posts: 7
Default Excel Bi-weekly time sheet change dates to Thursday- Wednesday

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?