+ Reply to Thread
Results 1 to 8 of 8

monthly Calendar in Excel

  1. #1
    Registered User
    Join Date
    02-18-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    41

    monthly Calendar in Excel

    Hi,

    I'm trying to put a monthly Calendar in one of the Excel Sheet. Can someone help me to put that?

    Thanks a lot.

    Regards, John

  2. #2
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: monthly Calendar in Excel

    What type of layout?

    there are many at :-
    http://office.microsoft.com/en-us/te...101850726.aspx
    Regards
    Darren

    Update 12-Nov-2010 Still job hunting!

    If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.

    Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!


  3. #3
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: monthly Calendar in Excel

    Do you just need dates?
    Do you need blank cells on each date for information?
    Do you want all days as a long list or weekdays across the top?
    What Day of the week do you want it to start with?

  4. #4
    Registered User
    Join Date
    02-18-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: monthly Calendar in Excel

    I intend to put a monthly calendar like for December, so that i can put tasks within each date as every day there are multiple tasks involved, also if in the side if there is any space/column of all the months, so that i can put tasks for each month.

    Hope this helps.

    Thanks - John

  5. #5
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: monthly Calendar in Excel

    Try this, you can change the month just by typing the new date in the Header Cell December 2010!

    Just make sure the date is the 1st of the month you want!
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-18-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: monthly Calendar in Excel

    Thanks !

    okay, how i can copy it to other existing excel sheet? I try copy and paste, but it just copied the month, and table, no dates.

    John.

  7. #7
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: monthly Calendar in Excel

    it has to be pasted to cell b2, if you copy it to another cell, you need to Search and replace

    $b$2 and replace with the new start cell

  8. #8
    Registered User
    Join Date
    02-18-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: monthly Calendar in Excel

    okay, thanks a lot !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1