Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How can I import or create a calendar with Microsoft Excel (https://www.askmehelpdesk.com/showthread.php?t=597407)

  • Sep 15, 2011, 02:51 PM
    joewren18
    How can I import or create a calendar with Microsoft Excel
    I created one by just imputing the numbers but it took a very long time. Is there a better/faster way to do this. Thanks for any help
  • Sep 15, 2011, 03:40 PM
    Scleros
    There are numerous free and paid calendar tools and templates for Excel available through the Internet. For example, see Excel Calendar Templates or search for "Excel calendar" at your favorite search engine.
  • Sep 15, 2011, 04:36 PM
    joewren18
    Thanks, I have seen the templates. I was more trying to create my own and understand the formula.
  • Sep 15, 2011, 05:03 PM
    ScottGem
    Define what you mean by a calendar. What formulas are you referring to?
  • Oct 30, 2011, 04:01 AM
    ExcelTemplates
    Joe,

    Here are some date related formulas:
    =Now() This inserts the current day on your spreadsheet. You can format it to show the date only or date and time.

    If you have a date in one cell. You can add a number to it to get another date. For example, if you have October 30 in cell A1. You can enter a formula in another cell in your spreadsheet (example B1) like this: =A1+7

    The formula will give you date 7 days from October 30 or November 6

  • All times are GMT -7. The time now is 06:07 PM.