ABCDEFG
1
Specify day name, occurrence in month & no. of working days to offset from it
2
3
Select the day of the weekMon
Created by Leighton Price
4
Select 1st, 2nd, 3rd, 4th or 5th occurrence of the day within the month5
5
Number of WORKING days to offset (negative = days BEFORE / positive = days AFTER) >>Notes on use
6
7
Enter task name for Todoist >>Put paper trash out
• To reset all inputs to the left at once, go to the menu bar at top, click on "Reset Ranges"
and then on "Reset Day Occurrence." You'll need to authorise the Apps Script.
8
Due Time: Hours (24h) (Optional) >>20
• You will need to ensure your labels have already been created in Todoist
ahead of pasting-in the output from this sheet.
9
Due Time: Mins (Optional) >>0
• When you've configured as desired, simply copy the details below
(highlighted in blue) & click on "add task" in a Todoist project on the web as per video.
10
Labels (Separate each with a space) >>
• Todoist will ask you, "Do you want to add x tasks?" Just click on the
"Add tasks" button.
11
No need to include @ with your labels
or p with priority number
• Your tasks will then be created with date, time, labels and priority,
if specified, all parsed correctly.👍
12
Priority (1 to 3 - Optional) >>1
10:08 pm - Saturday, 1 August 2026
13
14
First day of the monthHow many Mondays are there in the month?5th Mon of the MonthNo offset selectedTo copy & paste into Todoist ⬇️
15
Sat, 1 August 20265Mon, 31 August 2026Mon, 31 August 2026Put paper trash out 31 Aug 2026 at 20:00 p1
16
Tue, 1 September 20264
17
Thu, 1 October 20264
18
Sun, 1 November 20265Mon, 30 November 2026Mon, 30 November 2026Put paper trash out 30 Nov 2026 at 20:00 p1
19
Tue, 1 December 20264
20
Fri, 1 January 20274
21
Mon, 1 February 20274
22
Mon, 1 March 20275Mon, 29 March 2027Mon, 29 March 2027Put paper trash out 29 Mar 2027 at 20:00 p1
23
Thu, 1 April 20274
24
Sat, 1 May 20275Mon, 31 May 2027Mon, 31 May 2027Put paper trash out 31 May 2027 at 20:00 p1
25
Tue, 1 June 20274
26
Thu, 1 July 20274
27
Sun, 1 August 20275Mon, 30 August 2027Mon, 30 August 2027Put paper trash out 30 Aug 2027 at 20:00 p1
28
Wed, 1 September 20274
29
Fri, 1 October 20274
30
Mon, 1 November 20275Mon, 29 November 2027Mon, 29 November 2027Put paper trash out 29 Nov 2027 at 20:00 p1
31
Wed, 1 December 20274
32
Sat, 1 January 20285Mon, 31 January 2028Mon, 31 January 2028Put paper trash out 31 Jan 2028 at 20:00 p1
33
Tue, 1 February 20284
34
Wed, 1 March 20284
35
Sat, 1 April 20284
36
Mon, 1 May 20285Mon, 29 May 2028Mon, 29 May 2028Put paper trash out 29 May 2028 at 20:00 p1
37
Thu, 1 June 20284
38
Sat, 1 July 20285Mon, 31 July 2028Mon, 31 July 2028Put paper trash out 31 Jul 2028 at 20:00 p1
39
Tue, 1 August 20284
40
Fri, 1 September 20284
41
Sun, 1 October 20285Mon, 30 October 2028Mon, 30 October 2028Put paper trash out 30 Oct 2028 at 20:00 p1
42
Wed, 1 November 20284
43
Fri, 1 December 20284
44
Mon, 1 January 20295Mon, 29 January 2029Mon, 29 January 2029Put paper trash out 29 Jan 2029 at 20:00 p1
45
Thu, 1 February 20294
46
Thu, 1 March 20294
47
Sun, 1 April 20295Mon, 30 April 2029Mon, 30 April 2029Put paper trash out 30 Apr 2029 at 20:00 p1
48
Tue, 1 May 20294
49
Fri, 1 June 20294
50
Sun, 1 July 20295Mon, 30 July 2029Mon, 30 July 2029Put paper trash out 30 Jul 2029 at 20:00 p1
51
Wed, 1 August 20294
52
Sat, 1 September 20294
53
Mon, 1 October 20295Mon, 29 October 2029Mon, 29 October 2029Put paper trash out 29 Oct 2029 at 20:00 p1
54
Thu, 1 November 20294
55
Sat, 1 December 20295Mon, 31 December 2029Mon, 31 December 2029Put paper trash out 31 Dec 2029 at 20:00 p1
56
Tue, 1 January 20304
57
Fri, 1 February 20304
58
Fri, 1 March 20304
59
Mon, 1 April 20305Mon, 29 April 2030Mon, 29 April 2030Put paper trash out 29 Apr 2030 at 20:00 p1
60
Wed, 1 May 20304
61
Sat, 1 June 20304
62
Mon, 1 July 20305Mon, 29 July 2030Mon, 29 July 2030Put paper trash out 29 Jul 2030 at 20:00 p1
63