Is this date series possible?

Post Reply
PosWeyb
Posts: 7
Joined: Sun Oct 26, 2025 8:17 pm

Is this date series possible?

Post by PosWeyb »

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?
raitis.veksejs
SoftMaker Team
SoftMaker Team
Posts: 194
Joined: Fri Sep 15, 2017 1:29 am

Re: Is this date series possible?

Post by raitis.veksejs »

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 91 times
PosWeyb
Posts: 7
Joined: Sun Oct 26, 2025 8:17 pm

Re: Is this date series possible?

Post by PosWeyb »

Wow! So easy when you understand how to do it! Thanks so much!
PosWeyb
Posts: 7
Joined: Sun Oct 26, 2025 8:17 pm

Re: Is this date series possible?

Post by PosWeyb »

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 40 times
raitis.veksejs
SoftMaker Team
SoftMaker Team
Posts: 194
Joined: Fri Sep 15, 2017 1:29 am

Re: Is this date series possible?

Post by raitis.veksejs »

Please don't create duplicate posts.

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.
Post Reply

Return to “PlanMaker NX and 2024 for Windows”