Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post
    Hi Loungers....I am inexplicably stuck and have concluded that I am either tired or overthinking this.....I have made many calendars that show workdays (ie: Mon-Fri) and do not show weekends. I now need a calendar that shows all days and I cannot for the life of me figure it out....please see attached sample and if someone can give me the correct formula for the cells in col G, I would be very grateful....thanks, and my apologies for being so dense....)
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    In cell [G8] type

    =G7+1

    ..and copy it down

    zeddy

  3. #3
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post
    Thank you, zeddy......can't believe it was that simple, but as I said...I was probably overthinking it....thank you.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    I have days like that too.

    zeddy

Posting Permissions

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