Different number of periods and days, calculated from a fixed period, with varying years.

Is this what you want?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hi Popipipo and Forum

Sorry for my late return.

On closer examination, it appears that column "F" does not make an actual calculation, as expected.

Therefore, the calculation does not quite work, for example when there are shorter periods than, for example, a year.

I am sorry if I have been unclear.

But what I meant to show in column "F" (Days of the year) was:

How many "real days" are there within the selected period (e.g., 02-04-22 - 01-04-2023 in cell "C1" and "D1")... So, for shorter periods than 1 year, in column "A" and "B", the result will not fit with 365 days, in column "F"

The idea of this spreadsheet is to show the intersections of the days that lie - before, inside and after a given selected period.

I hope this makes more sense, and I kindly look forward to seeing your or someone's response - thank you in advance.

Dear Alan Moderator and Forum

Unfortunately, no one has replied to my latest and detailed comment in the post. And I also think that the solution to my task can be a "hard nut to crack".

Therefore, to minimize errors in the use of this fine Forum, I would like to ask if it is possible to move this post to the commercial forum and pay for a solution? And also because I am now short of time.

Ps. It's only the second time I've posted anything in here, so unfortunately, I'm not as knowledgeable as a user in here yet...

I hope for a friendly answer – thank you very much in advance.

I don't see where this was posted in commercial services so I will propose a solution here.
1. For column E: =MAX(0,$C$1-A3)
2. For column F: =IF(A3="","",DAYS(MIN(B3,D$1),MAX(A3,C$1))+IF(B3>D$1,1,0))
3. For column G: =MAX(0,B3-$D$1-1)
Let us know if you have any questions.