warriorpoet
New Member
- Joined
- Oct 7, 2010
- Messages
- 4
Hello everyone I'm new here but hopefully I can get some help with this question and of course be happy to help anyone that I can with my limited knowledge.
I need to show monthly invoice charges based on a bill cycle date, a service start date, and a service end date.
I will provide monthly rate for a service (variable on type of service) and will provide the start and end dates (changing for various services) as well as the bill cycle end day (the same for every account but may change from one account to the next so this being a variable in the formula would be great - could be 12th day of month or 1st day of month or whatever as it may be.) I've been able to accomplish the formula and have it work great for monthly invoices as well as total for a given time period EXCEPT the following cases:
The bill cycle does not start on the first of the month, and so the service start day() value may be < or > the billcycle day() value.
The start and end dates may be in the same month which causes an error in the calculation of the "in between months" when calculating the total.
Any ideas? Thanks.
I need to show monthly invoice charges based on a bill cycle date, a service start date, and a service end date.
I will provide monthly rate for a service (variable on type of service) and will provide the start and end dates (changing for various services) as well as the bill cycle end day (the same for every account but may change from one account to the next so this being a variable in the formula would be great - could be 12th day of month or 1st day of month or whatever as it may be.) I've been able to accomplish the formula and have it work great for monthly invoices as well as total for a given time period EXCEPT the following cases:
The bill cycle does not start on the first of the month, and so the service start day() value may be < or > the billcycle day() value.
The start and end dates may be in the same month which causes an error in the calculation of the "in between months" when calculating the total.
Any ideas? Thanks.