 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006correct 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/templates/TC060888761033.aspx?CategoryID=CT063 469961033 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 > 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 [quoted text clipped - 4 lines] > http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 > 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 > hi, > [quoted text clipped - 13 lines] > > http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 > > 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 >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 [quoted text clipped - 19 lines] >> > http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 >> > 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 > Change B14 to Wednesday or Friday then right-click, drag down and release. > Select Fill Series. [quoted text clipped - 26 lines] > >> > http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 > >> > Thank-you have a safe 4th Good point Marcello. Beats the hell out of drag/fill. Gord >you also could use a =weekday(a10) and format as dddd > [quoted text clipped - 34 lines] >> >> > http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 >> >> > Thank-you have a safe 4th Gord Dibben MS Excel MVP Change the date in K6 to whatever date you want to start from. Gord Dibben MS Excel MVP >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 [quoted text clipped - 4 lines] >http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT063 469961033 >Thank-you have a safe 4th
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.