is there a way to post dates without enetering 1 by 1 into cell

D

dustin

im looking for a way to enter dates for a whole Fiscal Year without entering
each date one by one into the A column. Or any ways to post a whole month at
a time.
 
R

Ragdyer

Enter your first date in a cell.
Then, *right* click and drag down, using the fill handle, as far as needed.

When you release the mouse, you will see many options to choose from.
Also, click on the last option (Series), for a *lot* more choices.
 
B

Biff

Here's one way:

I don't know when YOUR fy is so I'll use a calander year as an example.

Enter the first date in A1:

A1 = 1/1/2006

Select column A
Goto Edit>Fill>Series
Series in: Columns
Type: date
Date unit: Day
Step value: 1
Stop value: 12/31/2006 (in your case enter the last date of your fy)
OK

Biff
 
L

Larry

Hi Dustin, I'm a newbie too, been learnin' a lot here though.
I have this little bit of code that will enter the current date in a cell
when clicked, though you can put any date you want in that cell (until you
click it again, thenit goes to current) here it is:

'Automatically inserts today's date in cell in column C when selected
'if the cell was empty. Does not overwrite occupied cell. If you want a
different column then change the "ActiveCell.column= XX" to whatever number
you want.
i.e. A=1B=2C=3etc.

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If ActiveCell.Column = 3 Then 'Limits macro action to column C
If ActiveCell.Value = "" Then 'Check to see if Target cell empty
Selection.Value = Date 'Insert today's date in Target cell
End If
Else
End If
End Sub

Hope this helps you some, larry
 
Top