Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Denise
 
Posts: n/a
Default How do I change dates in student attendance?

I downloaded the 2004 - 2005 student attendance template but how do I change
the dates to make it a 2005 - 2006 attendance sheet? Please e-mail me this
infomation at
  #2   Report Post  
ScottO
 
Posts: n/a
Default

How you do it is going to depend on what form the "old Dates" are in ...
Are they text?
Are they Date Values?
Are they formula results?

Take a look at a few dates and post back with what you find.
Rgds,
ScottO

"Denise" wrote in message
...
| I downloaded the 2004 - 2005 student attendance template but how do I
change
| the dates to make it a 2005 - 2006 attendance sheet? Please e-mail me this
| infomation at


  #3   Report Post  
Denise
 
Posts: n/a
Default

Scott,

Thanks you for responding but I figured it out. I need to unlock the darn
thing. Thanks again!

"ScottO" wrote:

How you do it is going to depend on what form the "old Dates" are in ...
Are they text?
Are they Date Values?
Are they formula results?

Take a look at a few dates and post back with what you find.
Rgds,
ScottO

"Denise" wrote in message
...
| I downloaded the 2004 - 2005 student attendance template but how do I
change
| the dates to make it a 2005 - 2006 attendance sheet? Please e-mail me this
| infomation at



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do my dates change when I copy them between Excel worksheets? rrjohnsonia Excel Worksheet Functions 6 June 1st 05 09:42 PM
dates change to numbers Debbie Excel Worksheet Functions 1 March 29th 05 10:31 PM
Can I change a column of dates from USA to UK format? Michelle, Mencap Excel Discussion (Misc queries) 3 March 2nd 05 04:02 PM
In Excel spreadsheeet the dates change to the wrong date after we. ziptozipper Excel Discussion (Misc queries) 1 February 2nd 05 02:22 PM
Why does Excel Copy and Paste change dates from the original when. Excel changes dates in copy and paste Excel Discussion (Misc queries) 5 January 26th 05 05:08 PM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"