correct date/days in a template

I have found a template in M/S excel download that I would like to use but
how do I change the dates. The current template is dated 11/1/2004
-11/14/2004 The template is a biweekly time card which has to be changed
every 2 wks and additional days need to be added for when the the starting
date starts. This is the link if you care to look at it to help understand
what I am trying to explain
http://office.microsoft.com/en-us/te...CT063469961033
Thank-you have a safe 4th

hi,

did you try to change the 11/1/2004 to 11/15/2004?
if yes change the day in the k6 cell

hth
regards from Brazil
Marcelo

"Dumber than a pocket full of rocks" escreveu:

> I have found a template in M/S excel download that I would like to use but
> how do I change the dates. The current template is dated 11/1/2004
> -11/14/2004 The template is a biweekly time card which has to be changed
> every 2 wks and additional days need to be added for when the the starting
> date starts. This is the link if you care to look at it to help understand
> what I am trying to explain
> http://office.microsoft.com/en-us/te...CT063469961033
> Thank-you have a safe 4th

Thanks Marcelo Yes I did try to change the date but the date still starts
out on the first day which is monday and goes for 2 wks till sunday.... what
if I need to start on a wednesday or friday... is this templete set in
concrete can it be altered to suit my needs or do I have to build my own ???
Thanks Carl

"Marcelo" wrote:

> hi,
>
> did you try to change the 11/1/2004 to 11/15/2004?
> if yes change the day in the k6 cell
>
> hth
> regards from Brazil
> Marcelo
>
> "Dumber than a pocket full of rocks" escreveu:
>
> > I have found a template in M/S excel download that I would like to use but
> > how do I change the dates. The current template is dated 11/1/2004
> > -11/14/2004 The template is a biweekly time card which has to be changed
> > every 2 wks and additional days need to be added for when the the starting
> > date starts. This is the link if you care to look at it to help understand
> > what I am trying to explain
> > http://office.microsoft.com/en-us/te...CT063469961033
> > Thank-you have a safe 4th

Change the date in K6 to whatever date you want to start from.


Gord Dibben MS Excel MVP

On Mon, 3 Jul 2006 12:53:04 -0700, Dumber than a pocket full of rocks
<Dumberthanapocketfullofrocks@discussions.microsoft.com> wrote:

>I have found a template in M/S excel download that I would like to use but
>how do I change the dates. The current template is dated 11/1/2004
>-11/14/2004 The template is a biweekly time card which has to be changed
>every 2 wks and additional days need to be added for when the the starting
>date starts. This is the link if you care to look at it to help understand
>what I am trying to explain
>http://office.microsoft.com/en-us/te...CT063469961033
>Thank-you have a safe 4th

Change B14 to Wednesday or Friday then right-click, drag down and release.
Select Fill Series.

You can alter that Template as much as you wish.


Gord


On Mon, 3 Jul 2006 13:15:02 -0700, Dumber than a pocket full of rocks
<carlritcey@bendbroaband.com> wrote:

>Thanks Marcelo Yes I did try to change the date but the date still starts
>out on the first day which is monday and goes for 2 wks till sunday.... what
>if I need to start on a wednesday or friday... is this templete set in
>concrete can it be altered to suit my needs or do I have to build my own ???
>Thanks Carl
>
>"Marcelo" wrote:
>
>> hi,
>>
>> did you try to change the 11/1/2004 to 11/15/2004?
>> if yes change the day in the k6 cell
>>
>> hth
>> regards from Brazil
>> Marcelo
>>
>> "Dumber than a pocket full of rocks" escreveu:
>>
>> > I have found a template in M/S excel download that I would like to use but
>> > how do I change the dates. The current template is dated 11/1/2004
>> > -11/14/2004 The template is a biweekly time card which has to be changed
>> > every 2 wks and additional days need to be added for when the the starting
>> > date starts. This is the link if you care to look at it to help understand
>> > what I am trying to explain
>> > http://office.microsoft.com/en-us/te...CT063469961033
>> > Thank-you have a safe 4th

you also could use a =weekday(a10) and format as dddd

so when you change the date on the K6 cell the weekday will change auto...

hth
regards from Brazil
Marcelo

"Gord Dibben" escreveu:

> Change B14 to Wednesday or Friday then right-click, drag down and release.
> Select Fill Series.
>
> You can alter that Template as much as you wish.
>
>
> Gord
>
>
> On Mon, 3 Jul 2006 13:15:02 -0700, Dumber than a pocket full of rocks
> <carlritcey@bendbroaband.com> wrote:
>
> >Thanks Marcelo Yes I did try to change the date but the date still starts
> >out on the first day which is monday and goes for 2 wks till sunday.... what
> >if I need to start on a wednesday or friday... is this templete set in
> >concrete can it be altered to suit my needs or do I have to build my own ???
> >Thanks Carl
> >
> >"Marcelo" wrote:
> >
> >> hi,
> >>
> >> did you try to change the 11/1/2004 to 11/15/2004?
> >> if yes change the day in the k6 cell
> >>
> >> hth
> >> regards from Brazil
> >> Marcelo
> >>
> >> "Dumber than a pocket full of rocks" escreveu:
> >>
> >> > I have found a template in M/S excel download that I would like to use but
> >> > how do I change the dates. The current template is dated 11/1/2004
> >> > -11/14/2004 The template is a biweekly time card which has to be changed
> >> > every 2 wks and additional days need to be added for when the the starting
> >> > date starts. This is the link if you care to look at it to help understand
> >> > what I am trying to explain
> >> > http://office.microsoft.com/en-us/te...CT063469961033
> >> > Thank-you have a safe 4th
>
>

Good point Marcello.

Beats the hell out of drag/fill.


Gord

On Mon, 3 Jul 2006 15:18:02 -0700, Marcelo <Marcelo@discussions.microsoft.com>
wrote:

>you also could use a =weekday(a10) and format as dddd
>
>so when you change the date on the K6 cell the weekday will change auto...
>
>hth
>regards from Brazil
>Marcelo
>
>"Gord Dibben" escreveu:
>
>> Change B14 to Wednesday or Friday then right-click, drag down and release.
>> Select Fill Series.
>>
>> You can alter that Template as much as you wish.
>>
>>
>> Gord
>>
>>
>> On Mon, 3 Jul 2006 13:15:02 -0700, Dumber than a pocket full of rocks
>> <carlritcey@bendbroaband.com> wrote:
>>
>> >Thanks Marcelo Yes I did try to change the date but the date still starts
>> >out on the first day which is monday and goes for 2 wks till sunday.... what
>> >if I need to start on a wednesday or friday... is this templete set in
>> >concrete can it be altered to suit my needs or do I have to build my own ???
>> >Thanks Carl
>> >
>> >"Marcelo" wrote:
>> >
>> >> hi,
>> >>
>> >> did you try to change the 11/1/2004 to 11/15/2004?
>> >> if yes change the day in the k6 cell
>> >>
>> >> hth
>> >> regards from Brazil
>> >> Marcelo
>> >>
>> >> "Dumber than a pocket full of rocks" escreveu:
>> >>
>> >> > I have found a template in M/S excel download that I would like to use but
>> >> > how do I change the dates. The current template is dated 11/1/2004
>> >> > -11/14/2004 The template is a biweekly time card which has to be changed
>> >> > every 2 wks and additional days need to be added for when the the starting
>> >> > date starts. This is the link if you care to look at it to help understand
>> >> > what I am trying to explain
>> >> > http://office.microsoft.com/en-us/te...CT063469961033
>> >> > Thank-you have a safe 4th
>>
>>

Gord Dibben MS Excel MVP