LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Is There a Template for Annual Calendar



I have date related data scribbled on paper. It is a record of readout
data taken from an elapsed time meter that is connected to my oil
burner. I want to enter these data into XL and then do some number
crunching. The DATEDIF function is certainly going to be used. The
elapsed time data was not collected daily, so there will also be a lot
of Row deletions necessary.

So, I must have in a column every date of each year going back to JAN
of 1992. I have built such a listing from yr 2004 to present using
the autofill feature. I am now looking for a template, perhaps, or a
more elegant method. I will probably want to put each year onto a
separate worksheet, and then use a summary sheet to do calculations.

Is there a template available that would put 1 Jan 1992 through 31 Dec
2003 into say column A ?

Is there a function that will accomplish this task more elegantly and
more easily than the drag and auto fill method to fill in each year's
column of dates?

TNX.

Vince
 
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
I need a template for an annual calendar with week numbers mendozalaura Excel Discussion (Misc queries) 1 September 19th 06 04:12 PM
I need a template for Employee annual leave tracking Pamela Aranguiz Excel Discussion (Misc queries) 1 January 12th 06 01:35 AM
Where can I get an excel template to input annual leave? Tetley Excel Discussion (Misc queries) 1 November 30th 05 11:32 AM
Annual leave calender year 2006 - template Mohamed Excel Discussion (Misc queries) 1 November 29th 05 04:56 PM
how do I set up an annual calendar on one worksheet Ian Dee Excel Discussion (Misc queries) 3 November 6th 05 04:29 PM


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

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

About Us

"It's about Microsoft Excel"