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