Hello everyone,
I'm trying to calculate the number of months in a specific time range. For instance, I want to know the number of months between two dates but only in the first semester of a specific year. It means the module has to exclude, or reference 0, two dates that are not in that time range.
For example : the number of months in the first semester of 2018
1/1/2018 - 30/6/2018 = 6 months
1/3/2018 - 31/5/2018 = 3 months (march, april, may)
1/7/2018 - 01/10/2018 = 0 month
I'm still new to vba modules and I'm not sure I have to use them because it seems like a simple request, and yet I have been struggling for quite some time to find the solution.
Thank you for your help
Maxime