I am designing a school agenda. The format is roughly outlined below.
Month week nr Month
Monday NR Nr Thursday
Tuesday NR Nr Friday
Wednesday NR Nr Saturday Nr Sunday
Now, I want to number these days automatically, starting at monday the fourth of August. How do I perform such a task?
use the data merge function. Create a excel file with the right labels on first row, and start the year on the 4th August. Save as a csv file (or a tab delimited txt file). Create your basic template, select the file and let data merge do the rest.
Otherwise, look for the calendar script for Indesign, maybe you get a basic template to start with.
I don't understand RGRMS's layout but I think that can be done quickly in Excel, using the good date format and formulas, selecting the cells, copy them and directly paste the "table" in ID. Then 2 little grep researches.
Replace by nothing
On the 3rd column:
Replace by: $3$2$1
Obviously, depends on the layout!