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

correct date/days in a template
 

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

correct date/days in a template
 

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

correct date/days in a template
 

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
t.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

correct date/days in a template
 

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

correct date/days in a template
 

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

correct date/days in a template
 

Good point Marcello.

Beats the hell out of drag/fill.


Gord

On Mon, 3 Jul 2006 15:18:02 -0700, Marcelo
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
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