The idea is that when I fill in a certain year, Excel gives all the days in one row. And if it's possible I'd like Excel to indicate weekends as well.
Can anyone give me a hand here?
thx in advance?
Calendar and dates in MS Excel
Started by
bLuE_oMeGa
, Jun 27 2005 05:17 AM
#1
Posted 27 June 2005 - 05:17 AM
bLuE_oMeGa
-
- Member
-
- 26 posts
Member
The idea is that when I fill in a certain year, Excel gives all the days in one row. And if it's possible I'd like Excel to indicate weekends as well.
Can anyone give me a hand here?
thx in advance?
#2
Posted 08 July 2005 - 05:45 PM
Chronos0001
-
- Member
-
- 43 posts
Member
Working on matching the days to the date, but you may have to consider your option of one year in a single row.
Excel displays only 256 colums per row. Of course a year has 365. So you might want to do it on a six month basis per row when we find out how to match the days with the dates.
Good luck
Excel displays only 256 colums per row. Of course a year has 365. So you might want to do it on a six month basis per row when we find out how to match the days with the dates.
Good luck
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
