Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Calendar and dates in MS Excel


  • Please log in to reply

#1
bLuE_oMeGa

bLuE_oMeGa

    Member

  • Member
  • PipPip
  • 26 posts
I want to generate a complete list of all dates of a certain year in Excel.

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?
  • 0

Advertisements


#2
Chronos0001

Chronos0001

    Member

  • Member
  • PipPip
  • 43 posts
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
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP