Some question's

Thank you very much, Derek, but there seems to be a misunderstanding regarding what is needed. I want the days to be listed with the day number of the week, each on a separate line, not to calculate the number of days. I mean, each line should have today's date and the day number in the week, then the next line should follow with the next day, and so on(Since I want to remove some days and each day will have different hours, I want to generate the month and then perform operations on it) . As for the second point, it is very clear thank you . What about the third point, do you think there is a specific reason for that?

i have a strange problem that always occurs to me. After working on a specific form, suddenly when I return to it for testing, I find that the buttons or other elements do not work, and the problem is only resolved when I place another object, for example, another button, and put the code inside it. Sometimes, I have to create multiple instances of the same element for one of them to work!! What is the reason for that?

Thanks derek for your great support as always

i will tell you why i need the number of day's and tell me if i am wrong please   :

I'm working on an employee program, and this table is a temporary table, meaning that I won't need a mechanism to check for date repetitions because it will be reconstructed as needed. Regarding your mention of(I'm not sure what the point of having the 'day number' displayed), I want day's to appear as a number instead of the days for this ... the reason is simple: this table is for scheduling employees' workdays. If I want to remove weekly off days based on the date, I have to go through each date separately and check all the dates, which is a cumbersome process. However, this way, I can easily remove weekly off days using just numbers! Do you think this mechanism is wrong??? Now, I have another part left, which is how to remove days based on the date from the table. For example, from this date to that date, they must be removed. I'm currently working on this part. In your opinion, am I correct, or not? And this table is actually for reports...

i want to say just one word "wow"
That's amazing 

"The solution is perfect. Now, I will use a checkbox for each day of the week with a Boolean element in the table to mark the weekly holiday, as this will be easier than writing numbers. Dear Derek, you have an amazing solutions; thanks is not enough for you."

You saved me  

"Can I ask you a question? How can I be like you in finding solutions?"

In SQLite, days are defined based on international standards. Many standards, like ISO8601, consider Monday as the first day. However, in programming traditions, Sunday has been regarded as the first day, as is the case in some countries. The

strftime

function returns the number one for Sunday.