Creating a calendar month based on a date entered?

Hi acdc,

This is one way. It gives a two column calendar (Date, Notes).

If you want a calendar laid out with a week per row, that is more complex (but not impossible). Have a look at the Calendar Template in Template Chooser.

Enter Start Date and Weeks in the first table. Formula in C3 =B2 x 7. That tells the Calendar table where to stop. You can hide this column.

Calendar table has sufficient rows to hold the 8 weeks (and a few more).

Formula in A2 =Input::A2

Formula in A3 (and Fill Down)

=IF(ROW()<Input::C$2+2,A2+1,"")

That will calculate the next date until the row number exceeds Days +2 in the Input table Then it inserts "" (blank).

Regards,

Ian.

This doesn't answer your question directly, but have you had a look at the Calendar template (File > New and pick from the template chooser)?

You pick a date and it shows a calendar for the month plus smaller calendars for the previous and following months. You can "extend" it by simply adding columns to the right (by clicking the table and then clicking the "circle" symbol in its upper right corner).

SG

Hi acdc,

Welcome back.

I am not sure what you are trying to do, so I am guessing:

• you want to enter a start date (for example 4th July in the current year) and a number of weeks from that date;
• then create a monthly calendar starting on the first of that month, with weekdays across the top;
• no need for cells where you type notes;
• the calendar flows into following months (August in your example, to accommodate the 8 weeks);
• days of each month are highlighted to show the duration of a project;
• the calendar stops displaying dates after the end of August;

Please create a table manually to illustrate your aim. We can help with the formulas.

Regards,

Ian.

like SG asked... have you looked at the free, built-in calendar template (top left selection)?

Also Apple includes a program for calendaring shrewdly named "Calendar". Have you looked at that to see if it helps?

There are lot's of options.

Wayne

Are you looking for something like this?

I took the template and modified it, using a longer duration (planning period) than you specified in case you carry over into a third month.

The template looked intimidating at first. But all it does is calculate a beginning of the month date and beginning date of week for each month and everything flows from there. +DURATION(0,1) simply means add a day; +DURATION(1) means add a week.

Then, using a clever but simple bit of arithmetic, it calculates what I am calling an "anchor cell" upper left of each month table that uses the beginning of month date and beginning of month day of week to "go back in time" and calculate the date from the previous month that belongs there. The other values in the table flow from that anchor cell.

As with the template heavy use of Conditional Formatting is made to display or not display a particular date. I added a 'date is in the range' rule to the cells in each month to turn the text red.

I put a copy of the document here (Dropbox) if you want to have a look and modify it to fit your needs.

SG

I can't tell from the screenshot what might have gone wrong with the fourth month table. Note that the formula in the first row is different from the formula in subsequent rows. And you need to anchor the references (with $). I've revised the demo to add a sheet (tab) with four months, so you can check your formulas against it. It's at the same link as above.

SG

Hi SG,

Thanks for your insight to how the Calendar Template works (simple when you know how 😎), and how it can be adapted.

I have bookmarked this thread and saved your demo from Dropbox.

Regards,

Ian.