| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| World Cup tipping | Excel Worksheet Functions | |||
| World Cup tipping | New Users to Excel | |||
| Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
| =IF problem | Excel Discussion (Misc queries) | |||
| Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
Hybrid Mode
