by Anonymous on April 5th, 2009

Anonymous

Question

Help answer this question below.

New to excel. Wondering if a can make a dayplanner that is dated. I would like it to have 1page per day and print the entire year of my planner at one time.I think I think I need to use a formula or function but don't know which one to use. Thank you.

  • Like
  • Report

Answers. 4 helpful answers below.

  • by mubashiraziz on April 8th, 2009

    mubashiraziz

    I think you want to print whole Work Book ..... Make your Dates Planner on separate sheet of a work book ..... After making all sheets filled just Go in Print and Click Print Entire Work Book ............. your all sheets will be print

    No comments. Post one | Permalink

  • by Cyanotic Wasp on April 5th, 2009

    Cyanotic Wasp

    Most of what you're trying to do can be done without minor (maybe none at all) 'date' functions.

    For example, let's say that you put the year in a cell of its own: 2009 in, say, A1.

    And let's say that your formatted planner starts at C1, with January 1 of the year you choose, so at C1:
    =date( a1, 1, 1)
    You can format this cell to show
    "Weekday, 1 January 2009" (for one example)

    Now let's say that each 'page' (day) runs to 20 rows. Then at C21 you'd enter the formula:
    =C1 + 1
    And copy the formatting from C1 to display:
    "Next_weekday, 2 January 2009"

    From then on you just have to copy the cells from C21 through any multiple of 20 rows (since copy ranges have to be multiples of whatever your starting range is), so you'd copy the range C21:C40 through C41:C7300

    The rest is just formatting.

    No comments. Post one | Permalink

  • by Tinkerbell on April 5th, 2009

    Tinkerbell

    I am a bit confused at what it is you want exactly. But here are some general tips on dates etc in Excel.

    Firstly the f(x) symbol next to the input bar will give you a range of functions if you click on it. Just select Date & Time to see a list of the relevant functions.

    TODAY() is a useful one as it gives today's date and updates automatically.

    NOW() is similar but includes the time.

    Dates in Excel are stored as numbers (39854 for example) and each integer step is one day (so 39854 is one day above 39853). If you wish to add one day to a date (ex. in cell A1) you would use the following in B1

    =A1+1

    Times are fraction so 0.5 is equal to 12 hours. e.g. 39854.5 would be 12:00 noon on a 10th Feb 2009.

    If you give a few more details of what you want in a comment I'll see if I can help.

    No comments. Post one | Permalink

  • by tmot99 on April 5th, 2009

    tmot99

    Did you download a template or something?

    I can think of a number of ways to put in the dates, but I would need to know more about how you have it set up.

    My method would be to use a template. You can export data form a table into a template is easy. You could have a column that is the date. Format the column for the date format you prefer. enter one cell as a date. The lower right corner of the cell will have a black box. click and hold the black box and drag down. The cells will automatically increase each cell by one day.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

You're reading New to excel. Wondering if a can make a dayplanner that is dated. I would like it to have 1page per day and print the entire year of my planner at one time.I think I think I need to use a formula or function but don't know which one to use. Thank you.

Follow us on Facebook!

Related Ads

ANSWERBAG BUZZ

1 page per day calendar template for excel
How to make a day planner in excel