Take a look at the example "Generate date (calendar) table.". That includes some typical patterns for generating dates. Dates are an integer. Incrementing a date by seven days is done by adding 7. There are also functions like WeekStart() that will identify the first day of the week.