We know that months are different in number of days in each month ..

How can I divide any month to four parts ..based on the number of days in that month? and define which part we are in ..?

Example:

say I have this date 10 Dec 2019

To calculate the number of days of this date

Code: Select all

`Day(Application.EoMonth(Date, 0))`

I mean this is 31 days so the four parts should be 7 - 8 - 8 - 8

so first part would be from 1 to 7 ** second part would be 8 to 15 ** third part would be 16 to 23 ** fourth part would be 24 to 31

Now what I need is to define the day which is 10 Dec 2019 in which part of the four and return 1 or 2 or 3 or 4 according to the division clarified

so the expected result for 10 Dec 2019 >> the final output would be 2 as 10 is in the second part

Thanks advanced for help