Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates (Excel 2003)

    I am trying to create a calendar where I enter the first date and the rest of the days populate automatically. I want to show all days except sundays. I tried this but It keeps skipping days on me. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dates (Excel 2003)

    Can you tell us how you are trying to create the calendar?

  3. #3
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates (Excel 2003)

    I had the first day 7/4/2005 (DD/MM/YYY) in C2. The next day I had was C2+1, then C2+2 and so on till I hit saturday. Then I tried to drag the expression from the last cell for a few weeks but this didnt work.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dates (Excel 2003)

    Try this formula in C3:

    =C2+1+(WEEKDAY(C2)=7)

    and fill down as far as needed. If the cell above contains a Saturday, 2 days will be added, otherwise 1.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates (Excel 2003)

    Thanks Hans, just got to try it not and thats perfect. Much appreciated!

    Jordan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •