automatic dates in a column


    Sponsored Links


  • 1. Count unique records that also meet criteria
    I'm not sure if there is a formula to calculate what I want or if it will have to be a macro. I'd prefer a formula if possible. I have a workbook that has 2 sheets "Charts" and "Tooling PLOB". On my "Charts" tab I need it to count unique records from the "Tooling PLOB" that also meet certain criteria so I can chart it. (My boss doesn't like pivot tables.) For Example, from the "Tooling PLOB" I want to count how many in column I are "In Work" and is also a unique record. Column K has job #s that may be listed several times. I want each job # to only be counted once. Thanks for any help. -Brigette
  • 2. Finding Cell with Minor loss of fidelity
    I have a Excel Spreadsheet that was created in Excel 2003, but updated with Excel 2007. Whenever I save it, it runs the Compatibility Checker, and comes back with a 'Minor loss of fidelity' message. I would like to find the cell(s) that thie issue talking about. Is there a way to find which cell(s) have the issue, so I can fix them? -- Doug Krohn
  • 3. simple formula I'm sure using offset? or index?
    In cell b1 i have a named range "month". I want to be able to change the value of month and have the cooresponding values appear in b2-b6. What I'm after here is the formula I put in b2-b6. Thanks. a b c d e f 1 Product jan jan feb mar apr 2 prod-a 100 100 200 300 400 3 prod-b 125 125 225 350 450 4 prod-c 175 175 210 325 400 5 prod-d 190 190 220 350 325 6 prod-e 150 150 235 375 390
  • 4. Running Balance in the same cell...
    Ok, I have a spreadsheet that I"m creating to keep track of spending that is coming out of two different accounts. I want to be able to keep a running balance but in the same cell based on a condition. Is this possible. My spreadsheet looks like this. Cell A Cell B Cell C Cell D 1 9000 3000 2 R 100 3 P 50 4 R 400 5 P 100 What I'm trying to do is that based on if "Cell A" = "R", I want to subtract "Cell C" by 100 and then "Cell C" becomes "8900". Then If "Cell A" = "P", I want to subtract "Cell D" by "50" and then "Cell D" becomes "2950". So, then when the next "R" comes up, I want to take the new total of "8900" and subtract "400" from it leaving me with "8500" and continue down the line. Is this possible? What's the best way to go at this? The formula I have only works with multiple cells doing running balances and I don't want that. TL
  • 5. Insert function
    The Insert Ribbon will not open,just the Header/Footer portion will. I can not select Lines I have put in my document, to adjust them. Why??

automatic dates in a column

Postby gsbbr » Thu, 08 Jan 2004 02:29:23 GMT

I know this is an elementary question, but I do not have a manual, and
the "Help" doesn't open in Excel.  I've used Excel for several years,
made graphs, etc., but I still don't know how to do the following.

The first column needs to be consecutive dates, e.g., 1/1/04, 1/2/04,
1/3/04, 1/4/04, etc.  I have been entering each date in manually, but I
know there must be a simple way for Excel to do this for me.  I have to
enter dates for the entire year.

Can anyone help?  Thanks for your patience.

Message posted from  http://www.**--****.com/ 

Re: automatic dates in a column

Postby Peo Sjoblom » Thu, 08 Jan 2004 02:41:09 GMT

Put the date in the first cell, select the cell again, move the cursor to
the lower right corner of the cell,
copy it down by left clicking and holding down the mouse button while
dragging downwards



Peo Sjoblom

Similar Threads:

1.automatic month/date in a column

How can you enter only the day number in a column ie 2 and have it come up as 
date 02/02 or 2/2 

2.Automatic sum of a column when the other column has the same vaule

Is there an easier way to make the same date only show in one column and add 
the hours of the same dates together in that column than to do it all one by 

Date	                Hours
2008/03/26	1.50 
2008/03/26	7.50 
2008/03/26	1.50 
2008/03/27	1.00 
2008/03/27	10.50 
2008/03/28	8.00 
2008/03/28	1.00 
2008/03/28	5.00 

3.Automatic sum of a column when the other column has the same v

Thanx MAx you're a legend. :P

4.Separating dates from one column to Month, Date, Year columns

I'm looking for a way to take a list of dates that are being cut and pasted 
from an Access Database into excel and separate it so I can sort by Month, 
Day, Year.  The data seems to be recognized in Excel as a date because it 
sorts by the the year.  The format is mm/dd/yyyy.  When I try to change the 
format to anything else, it won't allow the change. column based on existing date column

If your end date is in A1, then in B1 use:


"Spence" < XXXX@XXXXX.COM > wrote in message
news:185f601c41b33$5d5e9c20$ XXXX@XXXXX.COM ...
> What I need to do is simple (I hope.) I have a column
> called END DATE and I need to generate another column
> START DATE based on the END DATE records. Each record in
> the START DATE column needs to be 365 days earlier than
> the date in the existing END DATE record. So, I'm looking
> for something like this:
> 12/04/2005        12/03/2004
> 01/25/2004        01/24/2003
> I'm hoping there's an easy function to save me from having
> to enter all these start dates manually. Any help is
> appreciated.
> Thanks,
> Spence

6. Referencing date column A & time column B to get info from column

7. Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field

8. Export to Excel with Automatic Date Name

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 92 guest