Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need a template for an annual calendar with week numbers | Excel Discussion (Misc queries) | |||
I need a template for Employee annual leave tracking | Excel Discussion (Misc queries) | |||
Where can I get an excel template to input annual leave? | Excel Discussion (Misc queries) | |||
Annual leave calender year 2006 - template | Excel Discussion (Misc queries) | |||
how do I set up an annual calendar on one worksheet | Excel Discussion (Misc queries) |