I have been trying to understand the auto fill series, and am not sure Planmaker can do what I want.
I am setting up a schedule where there are classes each week on Tuesdays and Fridays.
I want to put the dates in for 10 weeks.
An example series would be: 12/16/2025, 12/19/2025, 12/23/2025, 12/30/2025, 1/2/2026, 1/6/2026 etc.
I haven't figured out a way to do it...can anyone else?
Is this date series possible?
-
raitis.veksejs
- SoftMaker Team

- Posts: 194
- Joined: Fri Sep 15, 2017 1:29 am
Re: Is this date series possible?
Hello! Instead of the 'Classic' series, you can simply use a formula like =YourDate+7 to increment by a week. If you need to count how many Tuesdays or Fridays are in your list, you can use a formula to track those specific weekly occurrences. Please see the attached example file for more details.
- Attachments
-
- Thuesdays&Fridays-10weeks.xlsx
- (5.99 KiB) Downloaded 92 times
Re: Is this date series possible?
Wow! So easy when you understand how to do it! Thanks so much!
Re: Is this date series possible?
Well, not so easy. Can anyone tell me why I am getting an error on the formulas in cells H8 through W8? It is a simple forumula =cell + 7...
- Attachments
-
- Playwith.pmdx
- (190.47 KiB) Downloaded 41 times
-
raitis.veksejs
- SoftMaker Team

- Posts: 194
- Joined: Fri Sep 15, 2017 1:29 am
Re: Is this date series possible?
Please don't create duplicate posts.
Here is the answer that was sent to another post you made:
Here is the answer that was sent to another post you made:
raitis.veksejs wrote: Fri Jan 16, 2026 11:59 pm This issue occurs because the dates in F8 and G8 are considered text by the program rather than numeric date values.
To ensure PlanMaker recognizes dates correctly, enter the dates using the same format as your Windows system settings (you can check your taskbar, e.g., if it shows DD/MM/YYYY, MM-DD-YYYY or something else). Once PlanMaker identifies them as valid dates, it assigns them a hidden serial number, allowing them to be used in calculations.