| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically show date day by day
I need to make a list with all the days of the year in it. It is very
cumbersome to enter every day manually. Is there a way to do it automatically? Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show date day by day
In A1 enter:
1/1/2008 In A2 enter: =A1+1 and copy down -- Gary''s Student - gsnu200773 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show date day by day
Or for workdays only try this with a start date in A1
=WORKDAY(A1,1) and if you look in help you'll find how to exclude holidays too Mike "Bruno" wrote: I need to make a list with all the days of the year in it. It is very cumbersome to enter every day manually. Is there a way to do it automatically? Thank you! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show date day by day
Guess Bruno forgot to mention he was only interested in workdays? grrrr...?
"Gary''s Student" wrote: In A1 enter: 1/1/2008 In A2 enter: =A1+1 and copy down -- Gary''s Student - gsnu200773 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show date day by day
"a list with all the days of the year in it"
-- Gary''s Student - gsnu200773 "JLatham" wrote: Guess Bruno forgot to mention he was only interested in workdays? grrrr...? "Gary''s Student" wrote: In A1 enter: 1/1/2008 In A2 enter: =A1+1 and copy down -- Gary''s Student - gsnu200773 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show date day by day
That's pretty much what I read also, and would have provided much the same
answer. We can't hit 'm all dead center every time. "Gary''s Student" wrote: "a list with all the days of the year in it" -- Gary''s Student - gsnu200773 "JLatham" wrote: Guess Bruno forgot to mention he was only interested in workdays? grrrr...? "Gary''s Student" wrote: In A1 enter: 1/1/2008 In A2 enter: =A1+1 and copy down -- Gary''s Student - gsnu200773 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Hide row or show by hovering of mouse | Excel Discussion (Misc queries) | |||
| In Excel how do I get 2 zeros to show automatically after I enter. | Excel Discussion (Misc queries) | |||
| I want a cell to show the current filename automatically. | Excel Discussion (Misc queries) | |||
| Expired date to show up automatically | Excel Discussion (Misc queries) | |||
| How I show, automatically, the tab name on a cell, in Excel? | Excel Worksheet Functions | |||
Linear Mode
